Results 1 to 9 of 9
  1. #1
    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;
    I'm afraid the corrupted files are not only in sql files but other files like scripts etc and I can't check it one by one.

    Does anyone know why this problem occurs?

  2. #2
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    8,910
    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?
    Patrick William | RACK911 Labs | Software Security Auditing
    400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com

    www.HostingSecList.com - Security notices for the hosting community.

  3. #3
    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?

  4. #4
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    8,910
    Quote Originally Posted by aditan22 View Post
    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?
    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.
    Patrick William | RACK911 Labs | Software Security Auditing
    400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com

    www.HostingSecList.com - Security notices for the hosting community.

  5. #5
    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?

  6. #6
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    8,910
    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?
    Patrick William | RACK911 Labs | Software Security Auditing
    400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com

    www.HostingSecList.com - Security notices for the hosting community.

  7. #7
    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...

  8. #8
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    8,910
    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=679712
    Patrick William | RACK911 Labs | Software Security Auditing
    400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com

    www.HostingSecList.com - Security notices for the hosting community.

  9. #9
    Join Date
    Dec 2004
    Posts
    49
    I see, thank you very much for your guidance and your information, I really appreciate it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •