SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: MySQL Dump

  1. #1
    SitePoint Guru
    Join Date
    Mar 2001
    Location
    Highlands Ranch, Colorado
    Posts
    614
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Dump

    I need to load a big SQL file into a new MySQL database. I tried using phpMyAdmin but it fails. Are there any freeware tools or other tools than phpMyAdmin that out there that can assist with this task and handle such big files?

    I am on Windows 2000 Server with MySQL 3.23.52, Apache 1.3.27 and PHP 4.2.3 and my MySQL dump is about 32 megs big. I tried the whole thing on Linux (using Webmin because phpMyAdmin also failed on Linux) already but will also need to do it on Windows!

    Thanks!

    Christoph

  2. #2
    Non-Member
    Join Date
    Jun 2001
    Location
    Rome,GA
    Posts
    55
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    go to MySQL BIN folder and type:
    PHP Code:
    mysql -uUSER -pPASSWORD DBNAME DBDUMP 
    it works for me


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
  •