This is a discussion on "MySQL Backup" within the Databases section. This forum, and the thread "MySQL Backup are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
MySQL Backup
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
#1
|
|||
|
|||
|
Hi i have copied MySQL data folder from my server and replaced the data folder in my local system. I stopped mysql server in my local system and then copied the data folder. after copying when i restart the mysql server it does not connect and it terminates. How to make physical copy of data folder from one server to another. if i use SQLYog for backup it works fine. But i want to know how to make physical copy of data folder? Iam using InnoDB.
Thanks, Thanuja |
|
|
|
#2
|
|||
|
|||
|
Re: MySQL Backup
I would strongly advise you NOT to make a copy at the file system level, but to use mysqldump instead. By copying the file system, you are breaking the "no subversion" rule of database design, and except in the case of taking a full physical backup to restore in the event of a server crash, there's no reason.
Now going somewhat against my own comments - it is actually quite easy to copy myIsam tables at an OS level (shhh - don't tell everyone) but I wouldn't try it with InnoDb - you can have all sorts of issues such as the one you're reporting |
![]() |
| Tags |
| database |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Backup phpbb forum? | GuNka | PHP Forum | 8 | Apr 8th, 2008 21:13 |
| MySQL / PHP!!? | Webby46 | PHP Forum | 1 | Aug 30th, 2007 00:13 |
| need to BackUp MySql DB from VB.NET | capzman | Databases | 3 | Apr 5th, 2007 09:14 |
| systex error backup copy | Aaron1988 | Databases | 2 | Mar 4th, 2007 22:45 |
| PHP/MySQL | Web JobBot | Job Opportunities | 0 | Dec 19th, 2006 14:10 |