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

    Join Date
    Apr 2000
    Posts
    20
    Rep Power
    0
    My server provider does not have the best backup system in place, so I would like to periodically save all the data from my table and table descriptions. Therefore if I need to reload info after a server crash I can use the LOAD INFILE feature. I do not have FILE priveldges so I can not use the SELECT * INTO OUTFILE method.

    Any thoughts on the matter?
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Use mysqldump instead.

    mysqldump -u user -ppassword dbname > /path/to/your/dir/dump.sql

    to restore:

    mysql -u user -ppassword dbname < /path/to/your/dir/dump.sql

    Note you'll have to 'drop' and 'create' dbname before restoring.

Similar Threads

  1. multiple data directories with one MySQL server?
    By drdre69 in forum MySQL Help
    Replies: 4
    Last Post: October 29th, 2003, 07:17 PM
  2. How to 'que' MySQL data for review by PHP
    By andy85 in forum MySQL Help
    Replies: 3
    Last Post: March 6th, 2003, 10:09 PM
  3. Replies: 1
    Last Post: February 12th, 2003, 07:18 PM
  4. MySQL bad for large binary data? Oracle better?
    By torbjoen in forum MySQL Help
    Replies: 5
    Last Post: April 22nd, 2002, 04:10 AM
  5. reading MySQL data in a form field
    By calebdzahnd in forum PHP Development
    Replies: 1
    Last Post: September 9th, 2001, 01:10 PM

IMN logo majestic logo threadwatch logo seochat tools logo