#1
  1. No Profile Picture
    beans-curry
    Guest
    Devshed Newbie (0 - 499 posts)
    hello everyone

    i developed a php project using mysql as the database.i work on a win-nt machine....how do i export my database to the host server which runs linux???

    with regards...
    beans-curry

  2. #2
  3. No Profile Picture
    Carpe Diem
    Guest
    Devshed Newbie (0 - 499 posts)
    You need to use
    mysqldump -uroot -p database>database.sql

    Then on your host
    mysql -uusername -p database<database.sql



    ------------------
    Regards
    Darren
    --
    http://www.php4hosting.com/ $
    http://www.php4hosting.co.uk/
    PHP/MySQL Enabled Hosting/Dedicated Servers, Reseller Accounts

Similar Threads

  1. maysqladmin drop database syntax?
    By Slurm in forum MySQL Help
    Replies: 1
    Last Post: February 17th, 2004, 05:07 AM
  2. exporting database
    By black_lotus in forum MySQL Help
    Replies: 2
    Last Post: January 19th, 2004, 11:04 PM
  3. Importing, exporting and backing up database
    By mousa in forum MySQL Help
    Replies: 1
    Last Post: January 10th, 2004, 08:19 PM
  4. creating database & tables using ASP
    By pdxlooie in forum ASP Programming
    Replies: 2
    Last Post: December 26th, 2003, 05:27 PM
  5. distributing database reads among db slaves
    By JunkCookie in forum PHP Development
    Replies: 3
    Last Post: December 17th, 2003, 11:45 AM

IMN logo majestic logo threadwatch logo seochat tools logo