MYSQL :: Tables Import PhpBB/phpNuke

Import Into Multiple Tables
Ok, I've got three tables: users, patients, and user_fullnames. users has a primary key called id, while patients and user_fullnames have user_id fields that are foreign keyed to users.id. (table descriptions included below) I've got a text file containing a bunch of patients and columns f_name, m_name, l_name, sex and employer.

The data in my text file needs to be split up and inserted into the three tables. But because of the foreign key relationship, I can't just insert. I've got to insert a row into users, get the id, then insert into the other two tables. Does anyone have any advice on this? I'm about to write a php script to try this, but it seems like there's got to be a better way. Code:

Database Import To Over Ride Tables
I am generating auto-backups from simple database dumps. I'm then trying to import these on a regular basis (1 per week) into my test database through a auto-import script using PHP.

The problem I am having is that I can't seem to import into a database with the existing database table structures as it says 'Table already exitsts etc'. Is there a way when dumping the database I can specify 'if table exisits, drop and insert' similar to when you specify the requirement when exporting the datbase from phpmyadmin? I would prefer not dropping the database and regenerating it each time.

Import Some Tables Into Another Pre-existing Database
I want to dump all but 6 tables of a database into a sql file.
THe below is all but those six tables (do I have to wrote out all the table names??)

mysqldump -u root -p --opt dbname --tables view_history top_level_feed tag_set pending_tag_set pending_tag pending_fact namespaced_predicate main_search_ns_pred main_search_keywd_pred main_search_keywd_ns_pred main_search_facets main_search_descr_pred main_search_descr_ns_pred job_watcher job_log_entry item_address_watcher feed_watcher feed_log_entry feed_group feed entity_type_sample_uri entity_type dw_user content_search_ns_pred content_search_facets colleague_search_ns_pred cnt_search_keywd_pred cnt_search_keywd_ns_pred cnt_search_descr_pred cnt_search_descr_ns_pred browse_trigger_pred browse_trigger_ns_pred browse_template browse_ns_pred auto_feed > dbNameTables917.sql

Then import them into another database that has all these tables already.
I want to overwrite these tables with new data from the dump.

Will the mysqldump utility work or should I use the mysqlimport dbname --lock-tables --delete /path/to/sqlfile.sql work?

Import Tables From Another Non-Joomla Mysql File
Can someone tell me how I can import tables from another non-Joomla mysql file into Joomla? Basically it is just from one mySQL database into another. I use phpMyAdmin to import and export the entire file but I don't know how to do queries.

What I am trying to do is import all the articles I have built up using ccTiddlyWiki into Joomla. The only table names of relevance from the source file are:

id - title- body

IN other words, just the bare essentials.

The target files has a table called jos_content with columns:
id - title - title_alias - introtext - fulltext in that order and others but are not important.

I think it is fairly simple but I am not trained enough. I have 200 items so it would save an enormous amount of time!

It seems easy but I don't know enough about queries to do it well. I'm hoping that I can import the articles and then just go through the list in Joomla adding subtitles and so on to conform to Joomla database essentials.

There is another column called tags which I would be happy to have as well and I'm not bothered about start dates or anything else.

Phpbb
I am trying to set up PHPbb on my website using MySql 4.1 for my forums and I can't figure out how to create a new database and connect the database to the actual site and also I need to locate my:

1 database name
2 username
3 password

Phpbb With Mysql
Im going to uss phpbb as my forums but i dont have a clue where to get started. I know i have to create a database with mysql so it can connect, but i need help on how to start the database what should i put in it etc. I think i can use phpadmin, if i'm right. My host provides me with sql database and sql. Can any please help so i can get this working.

PHPBB Forums
I have MySQL 4.0 installed on my computer. I tried to install the PHPBB forums and set it to MYSQL 4.0, but i dont know a valid host name, or database name, database username, and password. How can i figure these things out.

MySQL With PHPbb?
Is it enough to just install mySQL on the webbserver for the phpbb-forum to work? Or do I have to create my own database-files with predefined tables too?

How To Read Phpbb
php file is loaded as codes on windows, but when u upload it on web u get the codes showed as image and stuff, so my question is, when using local host (windows xp) what prog or how i can see the php files not as codes/source when opening but as image or table or whatever.

Phpbb And Firefox
I am developping a forum using phpbb 2.0.17 (the lastest version). My forum url is www.qnhl.com. The problem is the following:
When you make a new post in a specific forum, this forum should show the "new post" icon instead of the "no new post" one.

But it's not the case in Mozilla firefox. The "no new post" is always there. What's the problem? Anything related with cookies? Note that I don't have this problem with Internet Explorer.

Phpbb Forum
I'm experiencing some problems trying to get my phpbb forum to work with mysql. I'm running the newest version of apache, and php is installed and working, but I'm not quite sure about what I have to do with the MySQL database part to get it working. If anyone knows of any tutorials or anything I would be grateful
Just for reference: I'm a newb when it comes to both php, and MySQL.

Phpbb: Username Already Taken After Deleting
I tested to delete phpbb user where user_post = 0.
After deletion, the query exe as normal.
But when I start to register, the phpBB immediately shows

Sorry, but the username is already taken.

instead of showing registeration form.

PhpBB Slow Loading
my site runs quickly except when a user hits forum (allready signed in or logging in) to login to the forums it takes 10x as long to get to the forums as it does the rest of the site, once in the forums its ok and runs as normal,is there any settings in SQL that can speed this up? or is there another problem.

PHPBB Can't Connect To Database
So i'm running Apache, PHP, and MySQL 4.x/5.x (i've attempted both) on Win2k.
When i try to install phpBB2 it says it can't connect to the database

Connection to database
You have not established a connection to MySQL 4.x.
ERROR: Access denied for user 'ODBC'@'localhost' (using password: NO)

Your database was not found.
ERROR: Access denied for user 'ODBC'@'localhost' (using password: NO)

MySQL Query For PhpBB
i want to display 5-10 latest phpBB2 posts on my homepage, and i know there are mods for the forum's index page that do similar thing, but i want to do it in my Perl script. I know how to connect to mySQL DB, but I don't know SQL..
could someone help me with mySQL query for X latest posts, so I would get the result containing user name, post topic, post date&time and post text?

Editing Not Working In PhpBB
After transfering my forum from one server to another, editing stopped working. You can go to phpBB's edit link, but when you try to edit the post nothing is changed. Topic titles can be edited, but nothing else can (including uploaded files with the attachment MOD).

If I edit it directly from phpMyAdmin it will work fine, but editing through the forum does nothing. On the last server it worked fine, although I'm pretty sure on my last server I was running on an older version of MySQL (3.x). On my new host (globat) I'm on MySQL 4.1.Nothing was changed in phpBB's scripts since the transfer, so nothing would have taken away the ability to edit post text. If anybody knows what is stopping these things I would greatly appreciate the help, since I've been looking for a solution for quite some time now.

Seprate Database For PHPBB
I have a databse for the main website that will contain ~15 tables.
Are there any advantages/disadvantages to merging and seprating and what is generally the best way to go?
I'm also interested to hear about (other) situations in wich you would choose for an additional database to increase my insight in the subject.

Help Rewriting A Slow Phpbb Query
I have a "glance" or "Recent Topics" list on my forums that have become fairly complex. I modified an already feature rich glance mod to allow users to select individual forums to exclude from showing topics in the list. As well when users are members of certain forum groups, they see topics from the group forum in the list, and they are highlighted a different colour.

The main SQL query to create the list often is showing up in the MySQL Slow_query log and I'm pretty sure is the main cause for the page loading slow.

I am no mysql Guru, so I thought I would seek the advice of some to improve or totaly rewrite this slow query.

PHP

$sql = "SELECT
    f.forum_id, f.forum_name, t.topic_title, t.topic_id, t.topic_last_post_id, t.topic_poster, t.topic_views, t.topic_replies, t.topic_type,
    p2.post_time, p2.poster_id,
    u.username as last_username,
    u2.username as author_username
FROM "
    . FORUMS_TABLE . " f, "
    . POSTS_TABLE . " p, "
    . TOPICS_TABLE . " t, "
    . POSTS_TABLE . " p2, "
    . USERS_TABLE . " u, "
    . USERS_TABLE . " u2
WHERE
    f.forum_id NOT IN (" . $forumsignore . $glance_recent_ignore . ")
    AND t.forum_id = f.forum_id
    AND p.post_id = t.topic_first_post_id
    AND p2.post_id = t.topic_last_post_id
    AND t.topic_moved_id = 0
    AND p2.poster_id = u.user_id
    AND t.topic_poster = u2.user_id
ORDER BY t.topic_last_post_id DESC";
$sql .= ($glance_recent_offset) ? " LIMIT " . $glance_recent_offset . ", " . $glance_num_recent : " LIMIT " . $glance_num_recent;

The "NOT IN" list varies per user, but here is an example:
NOT IN (77,75,76,25,26,37,63,64,66,67,67,1,25,26,37,70,28,75,76,78)

Mysql Login Error For Phpbb.
what i am used to do, if i have to select more rows by their id's i write

"SELECT * FROM table1 WHERE id IN (1,2,3,4,5)"

how can i do this via Execution in adodb (http://phplens.com/adodb/) ?

if i pass array, adodb starts complaining, if i implode it, it adds quotes around the string... any help?

$ado -> Execute("select * from table1 where id IN (?)", array(array(1,2,3,4,5)) ) //this does not work:(

MySQL Query Linking OpenCrypt & PhpBB
I understand that this will seem very novice to you all as developers, but I really need some expert eyes on my question because frankly the other forums have offered no real assistance.

I have a customer database system called OpenCrypt installed and running on my website. OpenCrypt has built in features to connect to my mySQL database as to create phpBB accounts similtaneously as general website accounts are created on my website!

Now. I am new to mySQL and am working on getting the correct syntax to work with my phpBB database. The following are my current fields in question:

user_id -> I need these id's to be created sequentially when new rows are added to my table, phpbb_users.

user_regdate -> What date parameters does phpBB read?

Thanks for your help! This is my current simple syntax used to similtaneously add phpBB rows to the table, where %variable% refers to my OpenCrypt fields:

INSERT INTO kylebt_Forums.phpbb_users SET `username` = '%username', `user_password`=MD5('%password%'), `user_email`='%email%'

Help With MYSQL And PHPBB On Server 2003 Standard
Trying to get help with this situation. I have installed PHPBB, PHP (4X) and
MySQL 4.1.

This is how I started out.

1. Installed MYSQL - ran setup - did FULL install - and entered in new
password when requested. MYSQL gave the green light when computer rebooted.
Created new database with CREATE DATABASE XXX; Also installed ODBC from
MYSQL site and created a "SITE DSN" for the ODBC

2. Installed PHP and verfied working and accessible

3. Installed PHPBB per the instructions on the site. Did the permissions as
instructed on config.php and install.php

4. Came to the install screen. Entered the info and password that I did with
MYSQL installation (Root was the username)

NOW SAYS - CANNOT CONNECT TO THE DATABASE. I do not know what to do at this
point.

Making Site Login Add Users To Phpbb Database Table
I have a login script for my site that I got off the net and was planning to use, but, I also wanted to make it so that when a user signed up thru the registration form it would also add them to the phpbb database's table. It wasn't discussed heavily from where i got the script but from what was mentioned the encryptions differ which results in a rejected login. Code:

Import From CSV
Using SQLyog 5.02 into MySQL server 5.0. Have built table structures and am
trying to import data from CSV. I get a rather non-descript dialog box
saying only "Error while importing data".

Does anyone have any suggestions on how to better accomplish this import or
how this error could be deciphered?

Import To 5 From 4
I have a site in a remote server that uses MySQL 4.1.10; MySQL charset is utf8 and MySQL connection collation is utf8_general_ci

I want to transport all of this tables to a new server that uses MySQL 5.0.45; charset and connection collation is the same.

I'm using phpmyadmin.

I'm not able to succeed!

When the table has 400 registers the error message is:
Fatal error: Maximum execution time of 300 seconds exceeded in /opt/lampp/phpmyadmin/libraries/string.lib.php on line 91

When the table has 30 registers the error is:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 29

What's wrong?

DB Import
I'm having problem importing an existing database to different server. Everytime it giving same error.

CREATE TABLE `7stat` (

`usrid` int( 11 ) default NULL ,
`date` date default NULL ,
`time` time default '00:00:00',
`pg_views` int( 11 ) default '0',
`num` float default NULL ,
`received_pay` char( 3 ) default 'no'
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 8

Why it is happening? what is the solution. I heard someone that i need spilit the database becoz it is big. But it is only 1.5MB.

CSV Import
I am using Win 2003 Server. MySql version is 14.12, distrib 5.0.27, for Win32. Obviously, I am new to MySql.

I've been developing a set of batch file scripts to automatically import CSV data daily. I was using the the following when suddenly it stopped working and said it couldn't find the CSV file.

The CSV file does exist and to make sure I had no typos I cut the file name from the temp_import.sql below and entered it in a Windows Explorer address box and Excel popped up and displayed the file. I tried using double-quotes and the back-tick around the file name but that caused a different error.

Notice that the error message has removed all of the backslashes from the file name.

As I said, I am developing it and may have perhaps mistyped something that I don't notice. It's as if I accidently changed something in the MySQL configuration with one of my commandline switches. I even tried rebooting the server but still the same thing. Code:

Sql Import
Im importing a large amount of data into Mysql using the sql upload import. The first couple of lines of my .sql file read as this

INSERT INTO `phpcatalog_alt_price` ( `alt_price_id` , `alt_price_name` , `product_id` , `alt_price_sku` , `alt_price_price` , `alt_price_op` , `alt_price_var1` , `alt_price_var2` , `alt_price_image1` , `alt_price_category` )
VALUES

The problem is that the 'product_id' field is going to start having numbers double up. What command can I insert here to tell Mysql to delete any old entries containing the same product_id as the SQL file I'm uploading? I just want to keep the new entries and any old entries containing a duplicate 'product_id' get deleted.

CSV Import
I am having trouble importing a CSV file into mySQL. I've basically narrowed it down to it having trouble reading quotation marks ("). The problem is that one of the columns is a measurement so they must remain in the data somehow. By replacing the " in Excel to another character I was able to successfully import the file.

Is there a way to import the file with the quotation marks intact? Or after the datafile is imported into mySQL how would I go about replacing a selected character in a certain column back into a quotation mark(") ?

Sql Import
I have a rather large file that I gzipped and imported into a database (a forum). I configured the forum to access the database and viewed it.
It all worked fine except for the fact that it doesn't display umlauts or any other "special" chars, like double-quotes, etc. properly.
A ü becomes Ã¼ and so on.
I un-gzipped the file and checked it with a text-editor and the umlauts and all other chars are fine in the file, displaying correctly.
The charset that was used in the sql file was latin1 so I thought I'd switch it to utf8 and re-do the import. Didn't help though.

Max Import
Is there a way to change the size limit for uploading in phpMyAdmin? I have a 40 meg zipcode file that will be a PITA to break apart.

Import
At work we have a huge Excel spreadsheet containing many rows, columns and sheets. It is a compilation of auto parts by our foreign parts buyer over the last four years. Each sheet is a different make (I.E. Audi, BMW, Etc). On each sheet are rows and columns with Mfg part numbers, descriptions, applicable years and our part numbers.

The project at hand is to get this data into a MySQL DB and then make it searchable on our Intranet by make, model, year or part number. I am familiar with Web servers, HTML, PHP, PERL, etc and have a running MySQL server that I manage with phpMyAdmin. This I do on my own for a non profit group who needed a Web site but I offered to help as our IT staff at work is limited.
I think the big hitch in the process will be getting this .XLS sheet into the DB in some sort of useable format (I think anyway). I am pretty sure once I do this I can build a custom SE using PHP and HTML connecting to the DB.

Import CSV
I have exported data from ms-access in CVS format (Comma Separated Values) & now I want to import them into mysql. I have created the same fields in the same order & same characteristics.
I use mysql 3.23 & a gui to operate it (Mysql Query Browser). I just cant import the data into the mysql tables.

Import Of Db
I have a database that has innodb tables with foreign keys. The export via phpmyadmin runs fine. When I try to import the db I receive foreign keys errors for tables that have a reliance on tables that come "after" it.The table structure is already in place, just that the tables are empty and I am trying to place the data in them.
Am I exporting this incorrectly? I have started doing this one table at a time, but that is a pain and slow. Is there another way?

Import A Csv
how do you correctly import a csv i keep getting a Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112 msg

CSV Import
while importing CSV file, I loose information about special characters (using: phpmyadmin). All those characters are converted into ? Can someone help me with that?

If converting those symbols firstly into some numbers (for example è into 001, È into 002, etc.) and then replacing those values in the MySQL records, how can I do that with help of PHP or some other command?

Import A .sql File
Ok, probably any easy task but not having much luck here. i exported to an .sql file a database from phpmyadmin. now, what i want to do is use that file to recreate the database on my local test machine. i do not have phpmyadmin installed on this system, so am looking for the proper query i can use at mysql command line to run.

Commandline Sql Import
mysql -u chmcradiology -p chmcradiology --max_allowed_packet=16M < projects_pc.sql

database and user exist (I can log in via the command line), max allowed packet because it's a 3 MB .sql file, and the .sql file does exist.

Running the command doesn't output any errors, it just does nothing (and quickly, too)

Import Problem
I am trying to export information from an Access database to Mysql. I am running into a problem on some tables in the date field. In access the date field's default value is Now() When i try to import this into mysql i get the following error

- SQL: CREATE TABLE `XPtrack` ( `Cnumber` INTEGER DEFAULT 0, `startxp` INTEGER DEFAULT 0, `finxp` INTEGER DEFAULT 0, `id` INTEGER DEFAULT 0, `date` DATETIME DEFAULT 'Now()', `info` VARCHAR(50), INDEX (`Cnumber`), INDEX (`id`)) TYPE=MyISAM
- Error: -2147467259 (80004005) [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt-log]Invalid default value for 'date'

Table Import
MySql limits the size of the records that you can import in one time. I have a large table coming from MS Access and I like (need) to import this in MySQL to work afterwards with this. What are the different ways to import in one time a large table. This MySQL database is my backend for a php driven website.

A conversion to a csv file first ?

Import From Text
I have a text file which contains names and dates. the date is in the format
Sep-11-2001 12:30 AM.
I tried to put the text into Excel and then used Navicat to import from Excel.
But everytime the dates are converted to 1/1/2001.

Text Import
I need to append records from an Excel spreadsheet to an existing table. I think I should start by converted the Excel sheet to a text file then importing from there. I have to do this using myPHPAdmin. Am I on the right path and how do I start and import using myPHPAdmin?

Import Query
Im trying to write a small app that enables a user 2 import a file into mysql.

Some of the txt files have column heading, is there in the MySQLImport fuinction to ignore this 1st line of the txt file (i.e the Headings line).

Import And Export
i am using mysql 7. i had a friend setup a php and mysql combination for my website. i am now trying to learn how to administrate it.

i would like to export the dbs from my prod server, and import on a test server, and view the tables. i believe i have figured out how to export: mysqldump -user -pass dbname > filename.sql, but am having trouble importing to a new mysql installation (possibly because i dont have a db there?)

can you please explain how to perform this?

Phpmyadmin Import
I have a account with GoDaddy.com and I want to import a sqldump into one of my databases that I created on GoDaddy. However I dont see the import tab or anyone else in the phpmyadmin panel. The only place I can do it at is when I click on Query Window > Import Files.. Code:

How To Import MS SQL MDF And LDF To MYSQL?
All I have is an MDF and LDF file from a MS SQL database & I want to
load them into MYSQL, but I don't have MS SQL. Any ideas? Is this possible?

Import Record
I have a mysql database (#1) with 25 tables and another mysql database (#2) with 100 tables. mysql(#2) has the same 25 tables as mysql (#1) but an additional 75 tables. I want to import the RECORDS from the 25 tables in my mysql(#1) to my same 25 tables in my mysql (#2).

additional information:
I am converting over from Oscommerce 2.2 (25 tables) to CRELoaded 6.15 shopping carts (100 tables)(25 same + 75 additional tables) and wanted to input the records from oscommerce database to creloaded database.

Excel Import
I am trying to import a large excel spreadsheet into a mysql 5 table. All fields import correctly but only one continues to give "null" data after import. It is a column set to Text on excel that contains data with the following format:

06/123456

Two digits for the year and a number up to six digits.

The relevant column in my mysql table is a varchar 10.

I suspect that the "/" creates problems.
Must I replace all "/" in my excel with "//" before importing?