38 users online (0 members and 38 guests)  


  Results 1 to 8 of 8
  1. #1
    lulu_sama's Avatar
    New User

    Status
    Offline
    Join Date
    Feb 2007
    Posts
    4

    Unhappy Help newbie in MYSQL

    Hey
    I'm newbie in mysql and I was trying to import SQL using phpmyadmin here is the message I got, please help me


    Warning: upload_max_filesize of 2097152 bytes exceeded - file [sql_file=localhost.sql.zip] not saved in Unknown on line 0

    Warning: Cannot add header information - headers already sent in c:\phpdev\phpmyadmin\libraries\ob.lib.php on line 53

    Warning: Cannot add header information - headers already sent in c:\phpdev\phpmyadmin\header.inc.php on line 27

    Warning: Cannot add header information - headers already sent in c:\phpdev\phpmyadmin\header.inc.php on line 28

    Warning: Cannot add header information - headers already sent in c:\phpdev\phpmyadmin\header.inc.php on line 29

    Warning: Cannot add header information - headers already sent in c:\phpdev\phpmyadmin\header.inc.php on line 30

    Warning: Cannot add header information - headers already sent in c:\phpdev\phpmyadmin\header.inc.php on line 32
    Database mysql running on localhost

    No SQL query!

  2. #2
    vinyl-junkie's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    721

    Re: Help newbie in MYSQL

    Your first warning message is the one you need to pay attention to. You are trying to import a file into phpMyAdmin that is larger than the maximum filesize available.
    Music Around The World - Collecting tips, trade
    and want lists, album reviews, & more

  3. #3
    lulu_sama's Avatar
    New User

    Status
    Offline
    Join Date
    Feb 2007
    Posts
    4

    upload_max_filesize exceeded

    How can I import large SQL files using phpmyadmin

  4. #4
    DeadMeatGF's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    381

    Re: :(

    Although I can't answer that precisely, you could always break it down into smaller files, and import them all.
    I don't have time to search myself just now, but head off to http://www.phpmyadmin.net/home_page/index.php - they'll have an answer ...

  5. #5
    HTML's Avatar
    Administrator

    Status
    Offline
    Join Date
    Aug 2000
    Posts
    3,445

    Follow HTML On Twitter Add HTML on Facebook Add HTML on Google+ Add HTML on Linkedin Visit HTML's Youtube Channel

    Re: :(

    threads merged
    AHFBWEB Less customers per server, more power for you!

    Business Class Shared Hosting

  6. #6
    lulu_sama's Avatar
    New User

    Status
    Offline
    Join Date
    Feb 2007
    Posts
    4

    Re: upload_max_filesize exceeded

    ok now here is the problem I get

    Error
    SQL query:

    -- phpMyAdmin SQL Dump
    -- version 2.6.4-pl3

    --
    -- Host: localhost:3306
    -- Generation Time: Feb 18, 2007 at 03:34 PM
    -- Server version: 4.1.12
    -- PHP Version: 5.0.5
    --
    -- Database: `mmorpg_main`
    --
    CREATE DATABASE `mmorpg_main` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;



    MySQL said:

    #1044 - Access denied for user 'vincentv'@'localhost' to database 'mmorpg_main'

  7. #7
    vinyl-junkie's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    721

    Re: upload_max_filesize exceeded

    Are these comment lines that are part of what phpMyAdmin is trying to interpret as a query?

    Code:
    -- phpMyAdmin SQL Dump
    -- version 2.6.4-pl3
    
    -- 
    -- Host: localhost:3306
    -- Generation Time: Feb 18, 2007 at 03:34 PM
    -- Server version: 4.1.12
    -- PHP Version: 5.0.5
    -- 
    -- Database: `mmorpg_main`
    --
    If so, remove these lines and try your query again. Let us know what happens.
    Music Around The World - Collecting tips, trade
    and want lists, album reviews, & more

  8. #8
    Zoup's Avatar
    New User

    Status
    Offline
    Join Date
    Mar 2007
    Posts
    8

    Re: upload_max_filesize exceeded

    Quote Originally Posted by lulu_sama View Post
    #1044 - Access denied for user 'vincentv'@'localhost' to database 'mmorpg_main'
    Do you have access to sa/root? If so, I would use that.

    Other than that this seems to be a rights / privileges problem.



Tags for this Thread