Migrating Database to different server

  • I am unable import my WordPress database.
    My old server saved the database file as alexande_wp206
    My new server has a different primary domain so the database automatically comes up as newdomain_wp206

    The first line in the SQL DB refers to a domain name and directory that is no longer a valid domain, I have called it ‘olddomain’

    This is the error message:
    SQL query:

    wp.26_54354.2016-12-19_05-07-530000644000115600011720000000315313025665451014567 0ustar alexandealexande<?php $str = ‘a:28:{s:3:\”sid\”;i:26;s:3:\”ver\”;s:5:\”4.3.3\”;s:5:\”itime\”;i:1444834287;s:8:\”softpath\”;s:49:\”/home/alexande/public_html/olddomain/wp\”;s:7:\”softurl\”;s:29:\”https://olddomain/wp\”;s:8:\”adminurl\”;s:9:\”wp-admin/\”;s:10:\”softdomain\”;s:19:\”olddomain\”;s:6:\”softdb\”;s:14:\”alexande_wp206\”;s:10:\”softdbuser\”;s:14:\”alexande_wp206\”;s:10:\”softdbhost\”;s:9:\”localhost\”;s:10:\”softdbpass\”;s:10:\”Q8-]194PS2\”;s:8:\”dbprefix\”;s:3:\[…]

    MySQL said: Documentation
    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘wp.26_54354.2016-12-19_05-07-53’ at line 1

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    How are you migrating your DB? I’m assuming phpMyAdmin export/import. The format of your “query” in the error message looks like a PHP export file. You cannot import that format directly into phpMyAdmin.

    You should use the uncompressed SQL format for export. If the file is too big, there’re options to export individual tables. Select the DB you want to export before picking the Export tab. The file will then have no database name that’s meaningful.

    When you import the file on the new server, first select your WP DB before picking the Import tab. Then the file will be imported into the right DB since the import file has no DB name.

    With uncompressed SQL, you can edit out undesirable portions as long as you maintain proper SQL syntax. The file is plain text, use a text editor just like you might for code files. Always keep an original copy if you intend to edit the file.

Viewing 1 replies (of 1 total)
  • The topic ‘Migrating Database to different server’ is closed to new replies.