MySQL Data restore

[namasteaz]

I upgraded to Tiger and it damaged my SQL database.

I have a backup file that is about 80 mb. The backup file was created
with PHPmyAdmin and is in .SQL format.

When I try to use PHPmyAdmin to load this .SQL file and restore my database, I get an error message that says NO SQL QUERY.

The file stops executing and NO data is restored.

Is this because the file is too big ??

Is there an application that will break the .SQL file down into smaller
parts ??

Is there a way to restore the data using the .SQL file and a direct SQL command line entry ??

I am new to this so please explain to me my options in as much detail as you can provide.

Thanks

Please Help !!!

J. Davis
[email protected]

[chiefgeek]

I’m no mySQL expert, but we use Navicat to admin our databases and it seems to work quite well.

http://www.navicat.com/

Perhaps it would be able to restore the file.

[derekhed]

I have run into some problems restoring these files using phpMyAdmin. There was some issue with my host and somehow odd characters were inserted into my backup.

If you are working with a remote host, an 80 Mb file uploaded to your server will probably time out your session anyway. Question: where is your DB server and do you have command line access to it?

Read through the docs for MySQL for instructions on importing data from a file and bypass phpMyAdmin. Then page through your backup file looking for offending bits or odd characters. In my case, the comments consisted of a line of dashes and MySQL choked on this. If you find a pattern of errors, I would use a command line script to fix them since loading up an 80 Mb file in BBEdit or something would make your eyes bleed.

[Author]

Posts