MySQL Forums
Forum List  »  MyISAM

Export geants database
Posted by: loriot alban
Date: August 25, 2015 03:41AM

Hello every one,

I have a problem, I need to transfert my database from a server to another.

The problem is some table have more than 20 millions entrees and when I do a myslqdump in ssh the machine start and finished by cancelling the dump.

the .sql dumped file is at 0 bite...

How to migrate my database if I can not do dumps ?

I have tried to copy in ftp all the files in
/var/lib/mysql

But when I put them in the new server

I ajust the permissions and the owner as mysql:mysql

and the result is

SQL show index from `InfResp_blacklist` failed : Table 'crossborder.InfResp_blacklist' doesn't exist

I don't know how I can igrate y database from a server to another

Any suggestions ?

By the way I am on a Centos 6.5


Alban Loriot

Options: ReplyQuote


Subject
Views
Written By
Posted
Export geants database
1545
August 25, 2015 03:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.