Backup your batabases w/o phpmyadmin

I often read threads about export/import data from MySQL and it’s always mentioned phpmyadmin as the only way to do that (with PHP indeed). But that’s not true, and it’s indeed the slower way to do that, expecially when importing large database files (because phpmyadmin has problems with large db)… Login Discovery Education This would be just a reminder 🙂 Research Paper On Ceo Pay Use an SSH client, like putty (if your database is on a remote server), to connect to your server and export the databse you want simply with:

Proposal And Dissertation Help Presentation

Georgetown University Masters Thesis mysqldump –user=username –password=1234 –databases your_database –opt –quote-names –allow-keywords –complete-insert | bzip2 -c > your_database.sql.bz2

download the .bz2 file created, unzip it using 7-zip (if you dont have any other uncompress utility), and backup your database in mysql using:

mysql –user=username –password your_database < your_database.sql

Help With Written College Application Essay Ever that’s faster than using “import” from phpmyadmin Can You Buy Research Papers Online http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html