Results 1 to 9 of 9
-
03-18-2008, 11:05 AM #1Junior Guru Wannabe
- Join Date
- Dec 2004
- Posts
- 49
Need help/suggestion, transferring account got errors
I need your help/suggestion regarding to my problem, I want to move an account from one host to other, but when creating the backup from old host the backup file always got corrupted, already asked the support and they can't identify the problem, instead they repeats creating backup which always produces corrupted file
This is one example of the corrupted file (I extract this from backup zip file):
DROP TABLE IF EXISTS `tablename`;
CREATE TABLE `tablename` (
`id` int(10) unsigned NOT NULL auto_increment,
`parent_id` int(10) unsigned NOT NULL default '0',
`name` varchar(100) NOT NULL,
`url` v-- Sending SELECT query...
-- Retrieving rows...
archar(50) NOT NULL,
`order_num` int(3) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
Does anyone know why this problem occurs?
-
03-18-2008, 11:27 AM #2Web Hosting Master
- Join Date
- Mar 2003
- Location
- Canada
- Posts
- 9,072
How are you creating the backup? Using a feature within your control panel, or actually logging in via SSH and doing a proper mysqldump then downloading it?
RACK911 Labs | Penetration Testing | https://www.RACK911Labs.ca
www.HostingSecList.com - Security Notices for the Hosting Community.
-
03-18-2008, 11:49 AM #3Junior Guru Wannabe
- Join Date
- Dec 2004
- Posts
- 49
I'm using cPanel full backup, I don't know how my host support created it. What are the options? and which one is more reliable?
-
03-18-2008, 12:16 PM #4Web Hosting Master
- Join Date
- Mar 2003
- Location
- Canada
- Posts
- 9,072
Ask your provider for SSH (shell) access and run the following command:
mysqldump -u database_username -p database_name > backup.sql
Change database_username to the user that is allowed to access the database, then change database_name to the actual database you want to backup. Using mysqldump directly is the preferred method of backing up a database, as occasionally the cPanel interface can cause problems - even though it technically uses mysqldump in the background.RACK911 Labs | Penetration Testing | https://www.RACK911Labs.ca
www.HostingSecList.com - Security Notices for the Hosting Community.
-
03-18-2008, 12:55 PM #5Junior Guru Wannabe
- Join Date
- Dec 2004
- Posts
- 49
Okay, thanks for your help.
Btw, that might solves the database problem, how about other files backup? are you assuming that the problem is only on mysqldump?
-
03-18-2008, 01:31 PM #6Web Hosting Master
- Join Date
- Mar 2003
- Location
- Canada
- Posts
- 9,072
It's safe to assume the problem is isolated to the MySQL dumps and no other content. How large is your database, and do you know how many tables are present?
RACK911 Labs | Penetration Testing | https://www.RACK911Labs.ca
www.HostingSecList.com - Security Notices for the Hosting Community.
-
03-18-2008, 03:32 PM #7Junior Guru Wannabe
- Join Date
- Dec 2004
- Posts
- 49
Okay, at least there's a good news
The data isn't so big, still a new site but there are many tables (CMS and Forum) and many tables got error in the sql like in example.
Btw, you're faster replying me than my host... lol.. I sent what you have suggested and no reply until now. It used to be a good host but I got many issues recently, well let's see...
-
03-18-2008, 10:23 PM #8Web Hosting Master
- Join Date
- Mar 2003
- Location
- Canada
- Posts
- 9,072
Looks like the issue you are experiencing is related to a recent cPanel pkgacct bug. Regardless, mysqldump via the shell prompt (SSH) is always the sure fire way compared to cPanel's backup and phpMyAdmin.
Further discussion:
http://www.webhostingtalk.com/showthread.php?t=679712RACK911 Labs | Penetration Testing | https://www.RACK911Labs.ca
www.HostingSecList.com - Security Notices for the Hosting Community.
-
03-19-2008, 12:39 AM #9Junior Guru Wannabe
- Join Date
- Dec 2004
- Posts
- 49
I see, thank you very much for your guidance and your information, I really appreciate it.