Note to self: Backup & Restore Procedure for MySQL Database (for WordPress etc.)

    Date: 05/13/05 (Java Web)    Keywords: mysql, database, sql

    Note: My WordPress database name is wordpress. I will use it in the example below. It will work for any MySQL database. (The procedure below will work with any version of WordPress too) Backup: mysqldump --opt wordpress | gzip -9 > wordpress.sql.gz Restore: gunzip wordpress.sql.gz mysql -u rootusername -p **** wordpress < wordpress.sql For detailed usage of mysqldump and mysql commands refer to [...]

    Source: http://blog.taragana.com/index.php/archive/note-to-self-backup-restore-procedure-for-mysql-database-for-wordpress-etc/

« Dr. Richard Stallman is... || IIT Mumbai professor... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home