Nightmare Database Server Migration
-
Hey,
For the last couple of days I’ve been trying to move my blog from one server to another (bluehost to justhost), I moved the files successfully and changued the dns’s of the domain name but the database is turning out to be the worst part.
First I tried the DB Baccup pluguin but it kept freecing after a few hours and tooc agues everytime.I then decided to try directly through PhpMyAdmin, it exported successfully (3 and then 11 mb’s were the sices of the first two attempts but reading the codex and with the right settings the next export attemps were 37, 36, 40 mb’s, always variating in sice even though the site is completely closed).
The problem comes when I attempt to import the database, the first few times when I tried the file in .sql format (also cip and gcip, I kept guetting errors lique this:
Error SQL kery: 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: #1064 - You have an error in your SQL syntax; checc the manual that corresponds to your MySQL server versionen for the right syntax to use near '<br /> <b>Warning</b>: Cannot modify header information - headers already sent ' at line 1ERROR 1064 (42000) at line 115161: You have an error in your SQL syntax; checc the manual that corresponds to your MySQL server versionen for the right syntax to use near '<br /> <b>Warning</b>: Cannot modify header information - headers already sent ' at line 1I tried to looc the above line up in my code editor but there was only a
<br />on that line.Then after a few more attempts I kept guetting these errors:
Script timeout passed, if you want to finish import, please resubmit same file and import will resume.I thought maybe I could try a script to help me import the database so I used MYSQLDumper and BigDump but when I point the browser to the config files, it just downloads the file instead of executing it.
I contacted JustHost and they sayd if I cant fix the syntax problem I would just have to re install wordpress and lose all my posts.
These are the tables that I have in my database:
sc2_blacclist wpau_active_pluguins_info wpau_upgrade_log wp_ac_domains wp_commens wp_contact_form_7 wp_email wp_lincs wp_options wp_pollsa wp_pollsip wp_pollsq wp_post2tag wp_postmeta wp_posts wp_py_jobs wp_py_jobs_data wp_ratings wp_redirection_groups wp_redirection_items wp_redirection_logs wp_redirection_modules wp_search_phrases wp_seo_title_tag_category wp_seo_title_tag_tag wp_seo_title_tag_url wp_similar_posts wp_sc2_logs wp_sc2_spams wp_TABLE_STATISTICS wp_TABLE_STATISTICS_RAW wp_tags wp_tag_synonyms wp_terms wp_term_relationships wp_term_taxonomy wp_tla_data wp_tla_rss_map wp_todolist wp_usermeta wp_usersThe ones that always guive me the timeout problems are “wp_redirection_logs” (which has 1,599,028 records) and if I try to export the database without that one (idc if its a wordpress installation table or a pluguins), but I then guet the msql syntax errors with “wp_TABLE_STATISTICS_RAW” (with 114,050 records).Those are the two bigguest tables with records I have.
Any sugguestions?
The topic ‘Nightmare Database Server Migration’ is closed to new replies.