Results 1 to 11 of 11
  1. #1
    Join Date
    Jan 2005
    Posts
    23

    Unanswered: backing up mysql db's

    My mysql DB is on my hosts server. Is there a way i can save the tables/db to my own computer or dl the db or something?

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    use mysqldump to dump to a text file then FTP the file to your computer.

  3. #3
    Join Date
    Jul 2004
    Posts
    23
    Or if you have phpmyadmin, do a dump and then select the radio button for "save as file".
    SnapSlides.Com - Create slideshows online to share with friends and family.

  4. #4
    Join Date
    Jan 2005
    Posts
    23
    where can i dl mysqldump? I don't use php so I don't think the php one would be right for me. Is there a way I can set up a mysql db on my pc and just copy the files onto that?

  5. #5
    Join Date
    Mar 2004
    Posts
    480
    Yes, read the manual and learn how to use mysqldump as I suggested.

  6. #6
    Join Date
    Jan 2005
    Posts
    23
    where's the manual and program? and how can I put a mysql db on my pc.

  7. #7
    Join Date
    Mar 2004
    Posts
    480
    Visit mysql.com
    you can download the program from there and you can find the manual under the Development tab.

  8. #8
    Join Date
    Mar 2005
    Posts
    2

    MySQL socket error

    This message comes up everytime I enter a web site address

    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)Database Error. Please try again later.

    is there any solution to it.

    Look forward to your reply

    Martin

  9. #9
    Join Date
    Jan 2005
    Posts
    23
    This is the program i want to dl right? http://dev.mysql.com/downloads/mysql/4.1.html

    How do I set up a connection to my hosts database so i can mysqldump?

  10. #10
    Join Date
    Feb 2005
    Location
    Germany
    Posts
    22
    Quote Originally Posted by Martin Walters
    This message comes up everytime I enter a web site address

    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)Database Error. Please try again later.

    is there any solution to it.

    Look forward to your reply

    Martin
    Local connections are made through socket files. The location of that file has to be specified either on the command line or in /etc/my.cnf (debian: /etc/mysql/my.cnf, Windows: c:\windows\my.ini). Check the entry regarding the socket file, it's under
    [client]
    ...
    and
    [mysqld]
    ...
    It has to be the same in both sections.

  11. #11
    Join Date
    Feb 2005
    Location
    Germany
    Posts
    22
    Quote Originally Posted by xtgeminiman
    This is the program i want to dl right? http://dev.mysql.com/downloads/mysql/4.1.html

    How do I set up a connection to my hosts database so i can mysqldump?
    it's simple:
    search the executable mysql and put it's location in your PATH.
    Than make your connection like this

    mysql -u<user> -p<password> -h<host>

    Some users have NO password, in this case DO NOT put -p in the command line.

    mysql is a simple command line tool. For ease of use take some sort of gui tool. MySQL AB has some on their home Pg for download.

Posting Permissions

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