Error Taking Backup

Discussion in 'Site & Server Administration' started by piyushjeswani, Jan 14, 2009.

  1. #1
    Hello,
    I have a forum and i am now shifting servers.
    So i want to take backup.
    I took backup from php myadmin from my old host.
    When i tried to to import it to my new host.
    I got some errors. Then i went to my index page, i could see all my created categories and forums as they were in my old host.
    But i couldn't see any threads.

    This is the error i am getting when i import to my new host:

    SQL query:
    
    
    Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:190) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/ob.lib.php on line 83
    
    Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:190) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php on line 22
    
    Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:190) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php on line 23
    
    Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:190) in /usr/local/cpanel/base/3rdparty/phpMy[...]
    
    MySQL said: Documentation
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br />
    <b>Warning</b>: Cannot modify header information - headers already sent ' at line 1
    Code (markup):
    Please help me someone.
     
    piyushjeswani, Jan 14, 2009 IP
  2. big-idea-guy

    big-idea-guy Peon

    Messages:
    150
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Here is what i would do

    1) clear the database, so that there is nothing there, then upload the mysql, do not run an install on that database prior to importing the mysql. when it is totally blank, do the import. You should keep your new forum installed and just make sure that all the config files are pointing to your server.

    2)if number one does not work, make a new export of the old forum, and then upload that export to a blank database and do the same as in #1 above.

    If that does not help, then i don't know what is wrong, sorry...
     
    big-idea-guy, Jan 14, 2009 IP
  3. hostingspeak

    hostingspeak Peon

    Messages:
    233
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Are you moving from a MySQL 5 host, to a MySQL 4 host?
     
    hostingspeak, Jan 15, 2009 IP