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

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 .

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)

ok.. thanks.. it's worked
:thumbsup