Can't import SQL database

  • orbachdl

    (@orbachdl)


    14 years, 3 months ago

    Hey guys,
    Here’s my situation. I’m trying to import an sql database onto my remote server so I can finally get this site live. When I went into MAMP phpmyadmin to export the database I see this: After trying to troubleshoot on the internet and export the database anyways I THINK I was able to do it. But I’m not sure, after all it said there were no tables. So then I go onto the cpanel and create a database called danielor_wordpress. with user danielor_admin and password root. (there are all placeholders). I give the user all privileges and go to upload the database using phpmyadmin. I get this error . I tried troubleshooting it with by changing settings in the wp-config file. the current settings are
    define(‘DB_NAME’, ‘danielor_wordpress’)
    define(‘DB_USER’, ‘danielor_admin’
    define(‘DB_PASSWORD’, ‘thesecretpassword’; (not my real password)
    define(‘DB_HOST’, ‘localhost’);
    does anyone have ANY idea how to solve that error? it’s killing me right now. thanks!!!!!!!

Viewing 1 replies (of 1 total)
  • Elan Technosys

    (@elantechnosys)

    14 years, 3 months ago

    Just export your database tables from MAMP and create a new data base in your host and then import tables via phpmyadmin on your host and change the data base details in wp-config.php and upload it on your host server.

Viewing 1 replies (of 1 total)

The topic ‘Can't import SQL database’ is closed to new replies.