importing a database to phpmyadmin

Discussion in 'Free Hosting' started by nsprink, Jan 13, 2010.

Thread Status:
Not open for further replies.
  1. nsprink

    nsprink New Member

    I few weeks ago my website databases were hacked or something so I deleted them. I have a back up and want to put them in but i'm getting this error when I try to import into phpmyadmin
  2. descalzo

    descalzo Grim Squeaker Community Support

    You have to create the database separately, using one of the cPanel tools, MySQL Databases or MySQL Database Wizard.

    You might have to edit the import file too, to remove the CREATE DATABASE part.
  3. Zubair

    Zubair Community Leader Community Support

    Extract the backup file if it is compressed
    open the SQL file and remove the following code
    Code:
    CREATE DATABASE `nsprink_joomla`
    
    then compress it back and upload it.
  4. nsprink

    nsprink New Member

    now im getting this..and I also tried deleted the default character set code and got another error.

    Error

    SQL query:
    --
    -- Database: `nsprink_joomla`
    --
    DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


    MySQL said: [​IMG]
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1
  5. descalzo

    descalzo Grim Squeaker Community Support

    And what was that error message (since the entire line was supposed to be deleted)?
  6. nsprink

    nsprink New Member

    It was saying it couldnt import the tables (which are the next lines in the .sql file)
  7. descalzo

    descalzo Grim Squeaker Community Support

    Exactly what did it say?

    And did you manually make the database?
Thread Status:
Not open for further replies.

Share This Page