This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Restore mysql database backup to new Sentora
#4
RE: Restore mysql database backup to new Sentora
Just a quick point on the above which I forgot to post. IF you can, it will be best to use mysqldump to dump the database into a .sql file on the first server, then move or download it to the next server or localhost. This will help maintain the consistency of the database. Moving the database files without using the dump can cause structural issues in the database with the ibdata, ibdata1 files. This can cause tables not to show. Use the mysqldump syntax shown below if you can access your server with root access.

$ mysqldump -u root -p *database-name* > *sqlbackupname*.sql
$ Enter mysql password: *your-mysql-password*

The above will create a database dump(backup) to a file called *sqlbackupname*.sql.
Then open your next server or your localhost and type the below to restore the database onto the server you want to move to:

$ mysql -u root -p *database-you-want-to-restore-to* < *sqlbackupname*.sql

I hope this helps someone in the future.
Reply
Thanks given by:


Messages In This Thread
RE: Restore mysql database backup to new Sentora - by kevwebbie - 09-30-2019, 09:50 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
Is Sentora dead? rajeevrrs 2 4 ,069 12-17-2022, 09:20 AM
Last Post: TGates
Sentora debug and error files johnnyp 0 1 ,638 10-27-2022, 06:16 PM
Last Post: johnnyp
Transfer Account to another Sentora BenI 1 3 ,427 07-21-2022, 07:19 PM
Last Post: Nigel

Forum Jump:


Users browsing this thread: 1 Guest(s)