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

    Join Date
    Jun 2000
    Posts
    9
    Rep Power
    0
    How would I go about doing this? Is there a script out there that will build a .sql file from it so that I can easily rebuild the database or os there some way to get my entire db off the server?

    Thanks in advance,
    ~Chris http://www.extremeforums.com

    ------------------
    "Reality is for people who lack imagination"
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    32
    Rep Power
    15
    On a similar issue - is there a way to transfer a MySQL database from one computer to another? From my experience I haven't heard of a way but if anyone out there has...
  4. #3
  5. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    For backing up entire MySQL databases' take a look at information on 'mysqldump'.

    mysqldump [options] database [table]

    Outputs the contents of the given database (or table within a database) as a series of
    ANSI SQL commands.

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  6. #4
  7. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    I do believe that the same could apply to the second question here.

    When you perform the dump, you would then
    get a long string of text data, which you could then later execute in a number of formats.

    easily turn it into a php file, or whathaveya'

    On a side note, mySQL also support incremental backups via: -- log-update option.

    This is used by launching you mysqld database server with the above option.

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  8. #5
  9. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    The fastest way to do a backup.. is to grab a copy of phpMyAdmin from php wizards.

    Use the dump schema options on the main
    database page, if you want the database structure and data, select the option and
    if you want it in an SQL file, check the
    "send" option..

    It's fast and simple, and setting the phpMyAdmin up is really very easy, one small
    file, upload it (if necessary) and then run it.

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  10. #6
  11. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    9
    Rep Power
    0
    Beautiful! I have had myphpadmin all along and did not know it could do this. Exactly what I wanted

    Thanks for your time.

    Chris Miller
    P.S Feel free to stop by my php forum anytime and share some knowledge http://www.extremeforums.com

    ------------------
    "Reality is for people who lack imagination"
  12. #7
  13. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by TechTalk:
    Beautiful! I have had myphpadmin all along and did not know it could do this. Exactly what I wanted

    Thanks for your time.

    Chris Miller
    P.S Feel free to stop by my php forum anytime and share some knowledge http://www.extremeforums.com
    [/quote]

    Eh, honestly, I am building my knowledge on this subject as I go along.. you asked a good question, and it just happened to be one that I had been curious about, and was reading on the subject at the time.

    I took a shot in the dark on the phpMyAdmin, and tried it before I posted it, that's why I had several responses.

    I will stop in and check out the site..

    Thanks.

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    79
    Rep Power
    15
    Using PhpMyAdmin for large databases/tables with lots of records really is a pain in the ***.
  16. #9
  17. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    Perth West Australia
    Posts
    757
    Rep Power
    15
    tantrum - thats cos phpMyAdmin has to read from the table its structure, format, field types index's etc - If you have very large tables - you are better off making your own admin page specific to that table - its heaps faster - even my dodgy admin routines are faster than phpMyAdmin for individual tables.

    ------------------
    Simon Wheeler
    FirePages -DHTML/PHP/MySQL

Similar Threads

  1. Replies: 13
    Last Post: June 4th, 2004, 04:49 PM
  2. Need advice designing a usage tracking database (MySQL)
    By Randolpho in forum Database Management
    Replies: 0
    Last Post: February 13th, 2004, 04:11 PM
  3. Replies: 3
    Last Post: February 11th, 2004, 08:30 AM
  4. Replies: 0
    Last Post: January 31st, 2004, 02:15 AM
  5. MYSQL database
    By isheikh in forum MySQL Help
    Replies: 3
    Last Post: January 14th, 2004, 10:58 PM

IMN logo majestic logo threadwatch logo seochat tools logo