In mysql, if the datas are to be changed from one system to other each with different operating system(windows)
u can take the copy of each database in folder format & ibdata0 or ibdata1 file inside data folder. stop the service of destination system & paste them in the concerned data folder & start the service.
Instead of taking the backup and restore of each & every database u can use this method also. if ur size of ibdata file is less u cannot copy since the data may be corrupted or lost.
u can take the copy of each database in folder format & ibdata0 or ibdata1 file inside data folder. stop the service of destination system & paste them in the concerned data folder & start the service.
Instead of taking the backup and restore of each & every database u can use this method also. if ur size of ibdata file is less u cannot copy since the data may be corrupted or lost.
No comments:
Post a Comment