|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
01-30-2006, 08:35 AM
|
#1 |
|
Too lazy to set a custom title
Join Date: Oct 2001
Location: Spartaaaaaaaaa
Posts: 14,136
|
how can I 'download' mySQL data to my HD?
I have a site that uses mySQL, the host says that they make back-ups but just to be on the safe side, how can I back up all the data which is in a mySQL table?
I'm looking for something simple and painles, like 'click here', 'press that button' and voila |
|
|
|
01-30-2006, 08:37 AM
|
#2 |
|
Confirmed User
Join Date: May 2004
Location: South Florida
Posts: 4,134
|
Check out mysqldump, it creates a text file with everything you need to recreate your database.
Easy fix is to setup a crontab that runs this daily and emails / ftp's you a copy every day. http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html |
|
|
|
|
01-30-2006, 08:50 AM
|
#3 |
|
Registered User
Join Date: Jun 2005
Posts: 1,813
|
|
|
|
|
|
01-30-2006, 08:52 AM
|
#4 | |
|
Too lazy to set a custom title
Join Date: Oct 2001
Location: Spartaaaaaaaaa
Posts: 14,136
|
Quote:
|
|
|
|
|
|
01-30-2006, 08:55 AM
|
#5 | |
|
Confirmed User
Join Date: May 2004
Location: South Florida
Posts: 4,134
|
Quote:
mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL |
|
|
|
|
|
01-30-2006, 08:57 AM
|
#6 |
|
Too lazy to set a custom title
Join Date: Jan 2005
Posts: 2,961
|
http://www.phpmyadmin.net/home_page/index.php
If you're not familiar with MySQL maintenence, then phpmyadmin is probably the tool for you.
__________________
 ZangoCash - Turn Your Traffic Into Ca$h. $.40 Per Install - No Tier |
|
|
|
|
01-30-2006, 09:04 AM
|
#7 | |
|
Too lazy to set a custom title
Join Date: Oct 2001
Location: Spartaaaaaaaaa
Posts: 14,136
|
Quote:
ok, thanks guys I'll give it a try later on, and see how it works  |
|
|
|
|
|
01-30-2006, 09:14 AM
|
#8 |
|
Confirmed User
Join Date: Feb 2004
Location: balmer
Posts: 436
|
I'd pay your host to do it for you after putting "download" in quotes.
__________________
oOooooooOOo |
|
|
|
|
01-30-2006, 09:24 AM
|
#9 | |
|
Too lazy to set a custom title
Join Date: Oct 2001
Location: Spartaaaaaaaaa
Posts: 14,136
|
Quote:
 |
|
|
|
|
|
01-30-2006, 09:27 AM
|
#10 |
|
Too lazy to set a custom title
Industry Role:
Join Date: Oct 2002
Location: Montreal, Quebec
Posts: 29,680
|
Some people like to complicate siimple things ...
SSH ??? Telnet ?? to dump a mysql db ... Do you have a Control Panel ( Cpanel, Exim, Plesk ). If yes, look for MySql and/or PhPmyAdmin. If not, change host... will save you further questions like this, such as cronjobs 
__________________
I know that Asspimple is stoopid ... As he says, it is a FACT ! But I can't figure out how he can breathe or type , at the same time .... |
|
|
|
