MySql quick question - GoFuckYourself.com

alex79 · 01-25-2004, 03:45 AM

i have a mySql database with around 100 tables.. what is the easyest way to copy all database to same server (make an identical copy of the database) without downloading the database on my computer (becouse the database is very big)
i also have installeted the phpMyAdmin and i have root access with ssh

fuzebox · 01-25-2004, 03:54 AM

If you've got shell access to the server, just mysqldump the database into a file.

# mysqldump -uuser -p databasename > database.sql

Then create a new database, and mysql -uuser -p databasename < database.sql .

mrthumbs · 01-25-2004, 04:02 AM

wasnt it -u username -ppassword ??

fuzebox · 01-25-2004, 04:03 AM

Quote:

Originally posted by mrthumbs
wasnt it -u username -ppassword ??

If you want your password in cleartext on your screen, or saved in your history file...

I guess I'm paranoid. (-p by itself will prompt you)

alex79 · 01-25-2004, 04:27 AM

ok.. thanks.. it's worked

01-25-2004, 03:45 AM	#1
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	MySql quick question i have a mySql database with around 100 tables.. what is the easyest way to copy all database to same server (make an identical copy of the database) without downloading the database on my computer (becouse the database is very big) i also have installeted the phpMyAdmin and i have root access with ssh

01-25-2004, 03:54 AM	#2
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,115	If you've got shell access to the server, just mysqldump the database into a file. # mysqldump -uuser -p databasename > database.sql Then create a new database, and mysql -uuser -p databasename < database.sql .

01-25-2004, 04:02 AM	#3
mrthumbs salad tossing sig guy Join Date: Apr 2002 Location: mrthumbs*gmail.com Posts: 11,702	wasnt it -u username -ppassword ??

01-25-2004, 04:27 AM	#5
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	ok.. thanks.. it's worked