#1
  1. No Profile Picture
    beans-curry
    Guest
    Devshed Newbie (0 - 499 posts)
    i've made a database on my win-nt m/c using the win32 binariy version of mysql...now how do i export this database to my database host server on the web??

    mssql has this export facility...what to do on linux????

    cheers
    beans-curry

  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    halifax
    Posts
    13
    Rep Power
    0
    just dump the DB to a text file ie
    mysqldump -u whoever -p databasename > whatever.txt
    then send that text file to your server..
    then simply run the mysqlimport function

    mysqlimport database whatever.txt
    hope it helps....
    cryogen

Similar Threads

  1. exporting database
    By black_lotus in forum MySQL Help
    Replies: 2
    Last Post: January 19th, 2004, 11:04 PM
  2. Importing, exporting and backing up database
    By mousa in forum MySQL Help
    Replies: 1
    Last Post: January 10th, 2004, 08:19 PM
  3. 2-dimensial array / mysql_fetch_array database problem
    By paulx82 in forum PHP Development
    Replies: 3
    Last Post: December 27th, 2003, 01:52 AM
  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