error message after importing of php database

  • john241

    (@john241)


    11 years, 1 month ago

    I am trying to back up my site.
    I backed up by “export” function the sql from my current site.
    I use “import” function to import the old sql into a new site so that I may set up a mirror site…
    But i keep getting error message and am unable to complete the importing.

    anybody can assist? I created a database with the same name as the old one but still unable to import. Help! thanks a lot.
    below is the errort message

    ————————————
    Error
    SQL query:

    — phpMyAdmin SQL Dump
    — version 2.9.0.2
    — http://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Apr 29, 2015 at 06:55 AM
    — Server version: 5.1.47
    — PHP Version: 5.2.13
    —
    — Database: mydatabasename
    —
    CREATE DATABASE mydatabasename DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said: Documentation
    #1044 – Access denied for user ‘myuser’@’localhost’ to database ‘mydatabasename’

Viewing 3 replies - 1 through 3 (of 3 total)
  • Lalit Nagrath

    (@laliz)

    11 years, 1 month ago

    remove this line from the file, save it , zip it and them import

    CREATE DATABASE mydatabasename DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    as you already created a database with same name.

    Thread Starter john241

    (@john241)

    11 years ago

    Hi laliz, thanks… tried that but didn’t work. Got script timeout once and then a list of errors on my second try.

    Assuming I do not delete that line, maybe I should not have created the database in the first place. and Import the old sql file into the Information Schema ? is that correct?

    Is there a less painful way to backup my WordPress website? =) appreciate any help.

    thanks!

    Lalit Nagrath

    (@laliz)

    11 years ago

    you can go into phpmyadmin, select the database and then choose export.

    then import this file after creating first a database and then import this into blank DB

    also if you face timeout you can increase timeout too
    php.net/manual/en/function.set-time-limit.php

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

The topic ‘error message after importing of php database’ is closed to new replies.