I forgot the commands you use to upload a database or dump it whatever you want to call it.... In shell

I have my whole database, I downloaded it from phpMyAdmin, and I want to transfer it back over to a new machine... what are the commands to put it back in there?

mysql -u user -p -d databasename < dumped_sql_file

Is their also a manner to dump ALL databases. Because that is needed when updating MySQL

Originally posted by Shyne
mysql -u user -p -d databasename < dumped_sql_file


Or just:
mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql

If you have mysqldump, :)

Originally posted by The Prohacker



Or just:
mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql

If you have mysqldump, :)

Shyne was talking about how to import a dump and you're talking about how to create such a dump :)

:beer:

this one work cept its like this

mysql -u user -p -D databasename < path/to/dumped_sql_file

thanks :)

Does anyone know how I can dump ALL databases so that I can upgrade MySQL??

Originally posted by Starhost
Does anyone know how I can dump ALL databases so that I can upgrade MySQL??

mysqldump -u user -p --all-databases

man mysqldump for more info