SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Guru
    Join Date
    Jul 2003
    Location
    england
    Posts
    823
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Question Cannot import Databases

    I have five databases that I need to import under one host server.

    I have tried different methods of importing, but I still get the same error message:

    Error

    SQL query:

    -- phpMyAdmin SQL Dump
    -- version 2.8.0.1
    -- http://www.phpmyadmin.net
    --
    -- Host: custl-19
    -- Generation Time: May 10, 2012 at 02:52 PM
    -- Server version: 5.0.91
    -- PHP Version: 4.4.9
    --
    -- Database: `ccart_sira`
    --
    CREATE DATABASE `ccart_sira` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

    MySQL said: Documentation
    #1044 - Access denied for user 'thisusername'@'%' to database 'ccart_sira'

    Any thoughts?

  2. #2
    SitePoint Member
    Join Date
    Jul 2008
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    create an empty db with the name you're importing then creat a user with the username

    With PHPmyadmin you can create an empty db with the name you're importing
    then create a user with the username and password,
    then import without the create database lines in the sql file or phrase it so the db is only created if it does not exist

    If the db is bigger than 8meg, download bigdump and use it to upload the big db.

  3. #3
    SitePoint Member
    Join Date
    Jul 2008
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    create an empty db with the name you're importing then create a user with the username

    Quote Originally Posted by toad78 View Post
    I have five databases that I need to import under one host server.

    I have tried different methods of importing, but I still get the same error message:

    Error

    SQL query:

    -- phpMyAdmin SQL Dump
    -- version 2.8.0.1
    -- http://www.phpmyadmin.net
    --
    -- Host: custl-19
    -- Generation Time: May 10, 2012 at 02:52 PM
    -- Server version: 5.0.91
    -- PHP Version: 4.4.9
    --
    -- Database: `ccart_sira`
    --
    CREATE DATABASE `ccart_sira` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

    MySQL said: Documentation
    #1044 - Access denied for user 'thisusername'@'%' to database 'ccart_sira'

    Any thoughts?


Bookmarks

Posting Permissions

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