SopranoHey,
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 changed the dns's of the domain name but the database is turning out to be the worst part.
First I tried the DB Backup plugin but it kept freezing after a few hours and took ages everytime.I then decided to try directly through PhpMyAdmin, it exported successfully (3 and then 11 mb's were the sizes 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 size 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 zip and gzip, I kept getting errors like this:
Error
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:
#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 1ERROR 1064 (42000) at line 115161: 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 1I tried to look 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 getting 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:
sk2_blacklist
wpau_active_plugins_info
wpau_upgrade_log
wp_ak_domains
wp_comments
wp_contact_form_7
wp_email
wp_links
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_sk2_logs
wp_sk2_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 give 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 (idk if its a wordpress installation table or a plugins), but I then get the msql syntax errors with "wp_TABLE_STATISTICS_RAW" (with 114,050 records).Those are the two biggest tables with records I have.
Any suggestions?
