0

So I am migrating over a Wordpress website it has quite a lot of custom fields, long titles and a lot of images.

When I make the migration over the database is not seen and Wordpress goes to a fresh install page, then it makes up a new database. In PhpMyAdmin I can see the old database is still there and it uses normal conventions like wp_commentmeta but the new version (the one WP has no problem seeing but no info from the old site) puts in odd characters like wp_z5v95e_commentmeta?

Even if I kill the database, rename it, re-du the con-fig file, get rid of the plugins, get rid of the theme, do a fresh WP install and I still get wp_z5v95e!

If I have to start from scratch and rebuild the site so be it but it also doesn't see the media library which is key due to the amount of images in the website.

Has anyone seen or know what this is?

Thanks

  • What you mean by "doesn't see the media library "? – Rishabh Oct 7 '16 at 8:19
  • Oh, so if I go to the media library in WP admin it doesn't see all the images that are on the server under the uploads folder - dates - images. – Nsokyi Oct 7 '16 at 8:21
  • If you can't see images in media library, then you must have used FTP to transfer images in Upload folder. By transferring with FTP Images won't show in media library Because images won't get their entry in database, on FTP upload. Two ways to see images in media, First: Add images manually from media library instead of FTP. Second: Import tables from previous DB to new DB so it got all entries in DB. No entry of image in database, no image in media library as simple as that. – Rishabh Oct 7 '16 at 8:29
  • 1
    If you just make up a new database, obviously you won't find any data in it. The strange characters you see added to your table names are configured in wp-config.php. Look for: $table_prefix = 'wp_';. – JHoffmann Oct 7 '16 at 8:41
  • 1
    The variable should be in there, it just has to be the same as before migration, or all tables have to be renamed. – JHoffmann Oct 7 '16 at 8:52
2

The strange characters you are referring to are part of the table prefix. This is configured with the variable $table_prefix in the file wp-config.php.

$table_prefix = 'wp_';

When migrating a WordPress installation and setting up a new wp-config.php file you have to make sure, the prefix stays exactly the same as in the former config file. Else all database tables have to be renamed accordingly.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.