No tables found in my Database after uploading my site to new server

  • Hello guys,

    I am trying to move my site to new server (and to new domain name).

    I did already changed database name, user name and salt key in wp_config.php document. I also have uploaded all wp files onto new server.

    Now I wanted to go to phpMyAdmin/Database and change site URL address
    in wp_options document.

    But, when I open my database, it says there are no tables in that database,
    so I obviously can’t update site URL.

    How come there are no tables, or anything even though I have uploaded all files onto the server? What I do wrong?

    Thank you for any advise.

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

  • Hi,

    Might be a bit of a stupid question but did you move your wordpress database from your old server to your new one!?

    What happends when you go to your domain name?

    Thread Starter Hobbart24

    (@hobbart24)

    Hi Benji,

    thanks for your support.

    – I did create new database on new server,
    – then I moved every single file of my wp site to new server. (after updating wp_config.php document with new database name, user name and salt key code)
    -now I try to change site URL, but I don’t know how…

    Yes you might have created a new database but you need to import the tables from your old database into the new one. That’s why it says there are no tables in your database.

    Go to the database using phpMyAdmin on the old server and select ‘export’ in the tabs at the top and then hit ‘go’. When the page has loaded copy everything in the text box.

    Then go to phpMyAdmin on the new server and select the database. Then hit the SQL icon next to the home icon in the top left and paste everything you copied into the textbox and hit go. This will import your wordpress tables. You should then see 12 tables in the database.

    You then need to go into wp_options and edit all the instances of your old domain to your new one.

    Thread Starter Hobbart24

    (@hobbart24)

    Hello Benji,

    thanks again so much for your support.
    It now works, however, when I go to my new website, it only shows plain, brand new wordpress site, with default twentyten theme. Nothing from all that website is actually seen. It just look like I would only download fresh wp.

    Any idea?

    I am also posting this question as a new topic, so it’s tagline is seen by others.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘No tables found in my Database after uploading my site to new server’ is closed to new replies.