MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: henry on 2014-02-03, 09:12:07

Title: How To Restore Mysqldumb Folder Partially?
Post by: henry on 2014-02-03, 09:12:07

I was using old Kloxo on a VPS hosting. Because of security issue http://forum.mratwork.com/kloxo-mr-releases-and-announcements/(security)-please-update-to-6-5-0-f6-5-1-a-to-2014013001/ , they automatically disabled my VPS, given me no choice for requesting a backup from the old VPS hosting provider.

One of the staff helped backup my data in the tarball ( tar.gz) format.

(http://getunlimitedwebhosting.com/tutorial/kloxovps/images/Tarball-2014-02-03_1551.png)

I downloaded for more than 10 hours by today.

I actually just want to restore 2 domains from the mysqldumb files after extracted tar.gz file.

(http://getunlimitedwebhosting.com/tutorial/kloxovps/images/1-2014-02-03_1536.png)

mysql;
(http://getunlimitedwebhosting.com/tutorial/kloxovps/images/2-2014-02-03_1536.png)

It is in folder format:
(http://getunlimitedwebhosting.com/tutorial/kloxovps/images/3a-2014-02-03_1537.png)

And also mysql table format:
(http://getunlimitedwebhosting.com/tutorial/kloxovps/images/3b-2014-02-03_1537.png)

Hence, my question is, how do I restore few of the folders as shown above?

Let's say this folder - bestfree_wordpr

I would like to restore it into my new VPS - on KloxoMr.




 

Title: Re: How To Restore Mysqldumb Folder Partially?
Post by: MRatWork on 2014-02-03, 09:22:54

1. Restore may trouble if database name longer than 16 chars. So needed make shorter. It's because new 'mysql rule' where database more than 16 chars.

2. If your database using myisam as storage-engine it's make simple backup.

Follow this steps:

1. In your old VPS run 'sh /script/mysql-convert --engine=myisam'.
2. In old VPS, backup all directories inside '/var/lib/mysql' (except mysql, performace_shema and test). Stop mysql service before backup.
3. In new VPS, restore the same directories to the same directory. Remember, also stop mysql stop.

Title: Re: How To Restore Mysqldumb Folder Partially?
Post by: henry on 2014-02-03, 09:47:34

I cannot access my old VPS and also old VPS SSH.
They already disabled the VPS and uploaded my files through tarball.
I already downloaded the tar.gz files , extracted, and now , it is in my hard drive.

So, how do I restore the mysql folder as shown above?

Title: Re: How To Restore Mysqldumb Folder Partially?
Post by: MRatWork on 2014-02-03, 09:59:01

Run 'mysql -u root -p[password] [databasename] < [dumpfile]' where [password] is root password, [databasename] is database name and [dumpfile] is dump file.

If you don't know mysql root password, go to panel and click 'reset mysql password' or run 'sh /script/reset-mysql-root-password [NEWPASSWORD]'.