MySql Backup and restoring backup from Command Line

Threaded Mode | Linear Mode

MySql Backup and restoring backup from Command Line

Author

Message

admin
~CM~

Posts: 147
Group: Administrators
Joined: Jul 2007
Status: Offline
Reputation: 0
Thank 0
2 was given thank in 2 posts

Post: #1

MySql Backup and restoring backup from Command Line

Taking Backup with mysqldump

Quote:

mysqldump -u root --add-drop-table user_dbname > /path/user_dbname.sql

Restoring Backup

Quote:

mysql -u user user_dbname < user_dbname.sql

Thanks & Regards
------------------
~CM~

This post was last modified: 09-28-2007 11:20 PM by admin.

09-28-2007 11:16 PM

« Next Oldest | Next Newest »

Possibly Related Threads...
Thread:		Author	Replies:	Views:	Last Post
	MySQL 5.0 backup from java	sanjay_sharma77	5	409	11-24-2008 03:44 AM Last Post: mario
	Reset MySQL root password :	Shital	0	246	02-14-2008 10:31 PM Last Post: Shital
	Top best 84 MySql Performance tips!	admin	0	371	12-11-2007 07:02 PM Last Post: admin
	10 tips for optimizing mysql queries	admin	0	239	07-31-2007 07:53 PM Last Post: admin

Forum Jump: