SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Nov 2001
    Location
    UK
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Simple MSQL Q. Transfer data how?

    Hi there,
    sorry to waste your time with such a trivial question, but i have spent far too long trying to find out how to do it. How can i transfer the data from my tables within a main database to a text file or something similar. As i need to upload them to a new server / directory?

    I appreciate your help a lot.

    THank you

    John

  2. #2
    Sports Publisher mjames's Avatar
    Join Date
    Jan 2000
    Location
    Charlotte, NC
    Posts
    5,891
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There are instructions here on how to backup, transfer, and move your MySQL database. I've used these instructions in working with my DBs and they work. Good luck! http://www.vbulletin.com/manual/movingservers.html

  3. #3
    SitePoint Member
    Join Date
    Mar 2002
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    create a script to dump your table or db but b4 that mkdir backup

    /usr/local/mysq/bin/mysqldump -u root -p <your_db> > /usr/local/mysql/backup

    this will create your code in constructing your db and get all data...check it out once done dumping


    on root

    $ mysql -u root -p > /usr/local/mysql/backup/<your_db>

    and thats it...same db and filed as from the original


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •