Database trouble while trying to go live

  • Hello all,

    I have created a website using LocalWP and everything was fine, but now I’m trying to host it for real and well… I wouldn’t be there if everything was fine.
    I have to admit that I’m only a webdesigner, and so have little understanding of databases; but this time everything falls on me, and I’m in a bit over my head.

    I didn’t even know that the website files and its database were handled separately by the hoster, for ewample.
    I installed duplicator on my wordpress, and it seemed to work. Except when I try to open the site it says “Error while trying to connect to database”. And that’s when my limited knowledge shows. I have tried uploading the package created by duplicator and also the integrated Adminer in Local but it seems they both export non adequate files.
    Non of them contain the exptected files (wp_commentmeta, comments, links, etc).

    So if someone could explain to me what I need to do to export a correct database to then upload it in myphpadmin, it would be greatly appreciated, thanks !

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

  • Hi gtvision,

    Sorry to hear there were issues transferring your site online. It happens to me more often than you’d think, and I’ve been using WordPress for years!

    Could you please follow this guide. It shows you how to manually transfer the database using phpMyAdmin. There are also Duplicator instructions if you need them.

    Thread Starter gtvision

    (@gtvision)

    Hi,
    thank you for your reply !
    I followed the procedure and it created a zip file containing all the relevant files (I think) in CSV format. But when I import the zip in myPHPadmin it works for quite a long time then I get this error message:
    SQL query:
    CREATE DATABASE IF NOT EXISTS CSV_DB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MYSQL answered:
    #1044 – forbidden access for user: ‘o755228’@’@%’. Base ‘CSV_DB’

    You’re welcome!

    Pretty sure the export format should be “sql.zip” and not CSV format.

    I also think that there’s some issue connecting the specified user with the database.

    The Duplicator developer has a quick install guide for setting up only the database. You can find that by clicking here.

    Or else, you could try using a different plugin like All-in-One WP Migration.

    Just to confirm, have you already created a database for your live site, either within phpMyAdmin or using a tool from your web host like cPanel?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database trouble while trying to go live’ is closed to new replies.