SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Feb 8, 2005, 04:36 #1
- Join Date
- Feb 2005
- Posts
- 2
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Mysql Data Backup & Restore Problem
Hi
I m newbie with mysql i m trying to make a copy of mysql database to cd drive and then restore this one to another machine, but i m getting problem
and i dont know the way to perform this task.
I use mysqlhotcopy and mysqldump programs but mysql> give an error message saying that you have an error with your syntex, here is the code line i m doing
mysql> mysqlhotcopy km c:\kmdata
here km is my database name and c:\kmdata is the path for new dir.
Please help me how can i perform my task.
-
Feb 10, 2005, 15:02 #2
- Join Date
- May 2004
- Location
- .
- Posts
- 227
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Hi,
Try to use this line:
mysqldump --opt -u USERNAME -p PASSWORD DATABASE > backup.sql
Then move the backup.sql to a CD.
Bookmarks