Hi Steven,

The problem is that when doing mysql_query (et al) from PHP, you DON'T 
specify the semicolon (;) at the end of a query. If you want to import 
this back into MySQL, do the following:

    1. Go into mysql and recreate the database manually -- the dump from 
mysqldump does NOT have a command to recreate the db.
    2. Run "mysql < textfile.sql", where textfile.sql is the dumpfile 
that was created. Be sure to use the -p option if you need to specify a 
password.

Good luck.

-bsh

steven wrote:

>I'm moving a mySQL db from my own server over to an external hosting
>company. there I don't have any root access of course... so I log in the
>mySQL-console.
>
>I made a 'db-dump' of my mySQL db (with Webmin), so I've got a textfile with
>a large amount of SQL-statements inside. (CREATE TABLE and INSERT INTO's)
>
>I tried the usual connection to the db, and then:
>
>@mysql_db_query('dbname', $myQ, $lid);
>
>where $myQ is a string of the whole textfile. I get this error:
>
>1064You have an error in your SQL syntax near '; INSERT INTO ISshipping
>VALUES (8,'966637132','EWW','Emery Worldwide','EWW93' at line 20
>
>it seems as if the first sql-statement is ok, but the query command from php
>can't handle multiple statements devided by the ';'...
>
>How can I import the whole file?
>
>tnx for any help!
>
>
>

-- 

=======================================================================
Billy S Halsey                              Software Problem Resolution
ESP Solaris Software
Email [EMAIL PROTECTED]                        Sun Microsystems, Inc
                           -NO DAY BUT TODAY-
=======================================================================




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to