SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    will code HTML for food Michel V's Avatar
    Join Date
    Sep 2000
    Location
    Corsica
    Posts
    552
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Huge backup, impossible to treat with phpmyadmin...

    Well, I tried several times to install the backup version of a MySQL database on my local computer (that's a 16MB sql file), but it seems phpmyadmin doesn't handle that big of a file...
    How can I execute a 16MB MySQL script ? (I am on Win98 for this computer)
    [blogger: zengun] [blogware contributor: wordpress]

  2. #2
    SitePoint Member atem451's Avatar
    Join Date
    May 2001
    Location
    Berlin
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    only little help...

    On Linux, you can simply use the SQL client.
    write on the commandline:
    mysql < backupfile.sql

    Maybe, there is something similar on Win...
    Footbag: Spread the Spirit

  3. #3
    SitePoint Wizard creole's Avatar
    Join Date
    Oct 2000
    Location
    Nashvegas Baby!
    Posts
    7,845
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Shin-Ma...

    You should be able to drop into DOS and exectue the same command.
    Adobe Certified Coldfusion MX 7 Developer
    Adobe Certified Advanced Coldfusion MX Developer
    My Blog (new) | My Family | My Freelance | My Recipes

  4. #4
    Non-Member MrLister's Avatar
    Join Date
    Feb 2001
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    or use mysqladmin it can handle any size and it's the one i use on servers that don't have telnet.

  5. #5
    SitePoint Member hsfournier's Avatar
    Join Date
    Apr 2001
    Location
    Canada
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you tried a different tool, like mySQL Front, which is a windows based GUI for mySQL. I haven't had any problems importing using it. You can get it at www.mysqlfront.de.

    Good luck
    Heidi Fournier

  6. #6
    will code HTML for food Michel V's Avatar
    Join Date
    Sep 2000
    Location
    Corsica
    Posts
    552
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm definitely going with mysqlFront then...
    Just noticed an error in the way phpMyAdmin is coded (well, an error that makes importing textfiles impossible on Win computers): it searches for "c:\phpdev3\php\somenumbers.tmp", and mysql says: "can't find chpdev3phpsomenumbers.tmp". Got slashes ?
    [blogger: zengun] [blogware contributor: wordpress]

  7. #7
    Talk to the /dev/null Theiggsta's Avatar
    Join Date
    Mar 2001
    Location
    Tampa, FL
    Posts
    376
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    use mysqldump in your shell...

    mysqldump -uusername -ppassword database > databasefile.sql


    Thats all
    Aaron "Theiggsta" Kalin
    Pixel Martini
    Ruby and Rails Developer


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
  •