MySQL DB Upload Problem

by 3 replies
4
Hello there,

I'm waiting to hear back from the programmer but I thought I would check for an answer here as well.

Here is what he told me to do with the SQL db they created for a site:

I do all that but when I upload the SQL db I get an error message about the db not existing. I created a mysql db from cpanel for the site but I just can't get the tables of the db created by uploading the SQL db. Any suggestions on how I can get this to work from the phpmyadmin import area?

Thanks.
#programming #mysql #problem #upload
  • I think if you open the SQL db using a text editor, you will see, near the top, something like:

    USE dbname;

    where dbname is the name of your database; try deleting that line and importing again

    if it doesn't work, paste here the error msg you receive
    • [1] reply
    • That was it. He had a dummy db name in .sql file. Once I replaced it with the db I created it worked. Thanks for your help Janet and Tomm.
  • Alan,

    Have you created a database and a "USER" to go with that database and "Granted" Permissions for them to use that Database?

    Is there a "config.php" file that needs that information inputting into it? and it's permissions changing to "777" "rwx-rwx-rwx"?

    As Thomm says, are there any error messages being given out?

    Import and export are usually easy with phpmyadmin -

    If you want to pm the database file and the hosting details I'll see if I can take a look see for you.

    Kindest regards,

    Janet Sawyer
  • Banned
    [DELETED]
  • Banned
    [DELETED]

Next Topics on Trending Feed