Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Unanswered: SQL file not working

    Hello everyone, how are you?

    I've been trying to restore a SQL database of mine but I simply can't get it to work. This is what appears when I attempt to restore the database:

    http://i43.tinypic.com/razvrp.png

    I initially exported the SQL with phpmyadmin's "Export" Feature.

    This is what my SQL code looks like:

    Gist Github version:
    https://gist.github.com/2302717
    https://raw.github.com/gist/2302717/...Database%20SQL

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    It is attempting to create a database that already exists. The database information_schema is a standard database used for storing information about each of the tables. I suggest that you remove from the backup file all lines of code that attempt to manipulate this database, adding or updating data in the tables within this database.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Apr 2012
    Posts
    2
    Quote Originally Posted by it-iss.com View Post
    It is attempting to create a database that already exists. The database information_schema is a standard database used for storing information about each of the tables. I suggest that you remove from the backup file all lines of code that attempt to manipulate this database, adding or updating data in the tables within this database.
    Thank you so much for the reply, I'll try to do it to the best of my ability but I have no knowledge of SQL. I think I'll figure it out, though. Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •