1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Rep Power
    How do I recover a mysqldump file in the windows version of Mysql?
    I know that on a Linux machine I just do a cat backup.sql | mysql -u root -p dbname
    What would the equivalent be for windows?
    Would I be doing it in DOS or in mysql?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Rep Power
    It's not all that different. Just do

    c:mysqlbin>mysql -u -p dbname < backup.sql

    and mysql will execute all the sql statements in the dump file.

Similar Threads

  1. mysqldump not working under windows
    By aumasta in forum MySQL Help
    Replies: 3
    Last Post: February 26th, 2004, 07:31 PM
  2. .NET vs. Windows API programming
    By anatol in forum .Net Development
    Replies: 5
    Last Post: January 23rd, 2004, 10:23 AM
  3. Matrix Reseller - Windows 2003 and FreeBSD $35 ColdFusion MX
    By vortech in forum Web Hosting Offers
    Replies: 0
    Last Post: October 14th, 2003, 07:07 PM
  4. Jobs: System Software Dev
    By sridharr in forum Hire A Programmer
    Replies: 0
    Last Post: August 1st, 2003, 03:12 AM
  5. Need Help Networking A Desktop and Labtop
    By grkgqmodel in forum Networking Help
    Replies: 1
    Last Post: June 20th, 2003, 02:55 PM

IMN logo majestic logo threadwatch logo seochat tools logo