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

    Join Date
    Apr 2000
    Posts
    6
    Rep Power
    0
    On the old server we have only user rights access to our database. So we cann't use such command as mysqldump. Could you suggest a way to move the database?

    Of course we can use the command SELECT FROM * table into OUTFILE 'foo.txt'; but unfortunately we don't know where will be created the output file. And our hoster does not want to tell us this information ;-(.



    ------------------
    The Russia Journal
  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
    If you have telnet access you can still use mysqldump.

    mysqldump -u yourusername -ppassword databasename > /path/to/your/root/sql.txt

    If not, you can install phpMyAdmin to your site and use it (if you have PHP support)
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    6
    Rep Power
    0
    Super!

    It works. My hoster have lost $100 which he wanted for this operation.

    Thank you very much,
    Alex.

    ------------------
    The Russia Journal

Similar Threads

  1. A virtual host database
    By spinkick in forum Apache Development
    Replies: 4
    Last Post: October 13th, 2004, 02:16 PM
  2. Replies: 6
    Last Post: January 29th, 2003, 01:34 PM
  3. move data from database a to database b
    By joyce in forum PHP Development
    Replies: 3
    Last Post: January 21st, 2002, 03:48 AM
  4. Installing MySQL on a virtual server
    By DiPesa in forum MySQL Help
    Replies: 1
    Last Post: June 25th, 2001, 09:54 PM
  5. database server
    By fcatz in forum MySQL Help
    Replies: 1
    Last Post: September 28th, 1999, 12:58 PM

IMN logo majestic logo threadwatch logo seochat tools logo