Dump a database

[petesmc]

Hi,

everywhere I've seen how to backup a database, but how do you restore one.

PhpMyADmin is refusing to restore it and was wondering if there was another way?

thanx

Peter

[Vinay]

phpMyAdmin is weird sometimes

here's the trick.. open up the SQL dump you had from phpMyAdmin, copy it into the clipboard, and then paste it in the query window for the specific database... do all this INSTEAD of uploading the file via phpMyAdmin .. and that way it should dump it more efficiently

your second option is dumping it via shell

mysql -u USERNAME -p DBNAME < file.sql

[petesmc]

My PC crashes sometimes when i try to copy the file: it is 495 pages or 800,000 characterss...AHHH.....

I'm trying to do the shell thing except i found it doesn't work. Shell i mean. I don;'t have access to shell....

I'll try copying again

Peter

[steven]

Pete-
To restore a database all you need to do is the following command.

mysql -uusername -ppassword database < backedupfile.sql

HTH
Steven

[Kevin Yank]

That's assuming you either have telnet/SSH access to your server, or your MySQL server allows you to connect directly from your own computer (in which case you'd install the 'mysql' program on your own computer and run it with the --host parameter).

[steven]

Yes, kyank is right. However, I know that pete has SSH/telnet access because we have the same host.