transferred mysql databases

  • hey,

    okay, basically my former host gave me my mysql files in an .sql text format. thinking, i guess, that i would set up new mysql databases in my new host and that i would import files (.sql) using adminphp.

    anyway, my problem is it imported okay, BUT much was missing in the blog.
    no article posts, pages, only a few banners graphics. the widgets i had were there. so can someone tell me WHAT THE F%%$ HAPPENED?

    i’m bummed that the post/page content were all gone. can the contents be in another folder in the home directory ‘backup’ folder i have? if so, what is the name? i can’t find anything related.

    please advise,

    alex

Viewing 3 replies - 1 through 3 (of 3 total)

  • If you used phpMyAdmin to restore your database then you should use phpMyAdmin and look at your posts table to see if your posts are there.

    If your posts table is called wp123_posts then make sure your $table_prefix in your wp-config.php is wp123_.

    Also review WordPress Backups

    Thread Starter thealexangroup

    (@thealexangroup)

    michael,

    thanx for reply. okay, i checked one of my mysql files and i have 2 different ‘$table_prefix’ names within. one is a prefix i named and the other starts with ” wp_ “. can i add more than one prefix to config file? or how should i approach this?

    thanx in advance,
    alex

    You can only have one $table_prefix so if you import your database via phpMyAdmin then you wnat the $table_prefix in your wp-config.php to point to those tables.

    So again, if your imported posts table is called wp123_posts then make sure your $table_prefix in your wp-config.php file is wp123_. Of course, replace the wp123_ with what your prefix is.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘transferred mysql databases’ is closed to new replies.