Re: [PHP] How to backup records in mySQL DB?
> We're beggining again but i'm not scared about the > Data. The data is posted online by users. I need to > have a way to backup my mySQL data. If possible, on > some other site location or in Hard Copy (As in a > file) or something. I don't know how to do any of > this. I have no idea what to do about it. Can anyone > make any suggestions & help? This is a MySQL question and not a PHP question. That being said if you have telnet/SSH access to your server create a script to use mysqldump then tar/gzip the result and mail or ftp the resulting file to the backup location. Then cron it to run as often as you want backups. To keep on topic you can use PHP as the scripting language to do this. Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] How to backup records in mySQL DB?
Dear Friend, If I were you, I would take my biz elsewhere. BTW, which company is that? Anyway, I will recommend you to use the phpMyAdmin. It's a mysql database management tool written in PHP, free of charge of course, that lets you manage your database. One of the cool things it that it dumps your database into a flat file with table creation and INSERT commands, so that in case you need to restore you databases, you just run the sql. I hope this helps. Mehmet. "Thomas Edison Jr." <[EMAIL PROTECTED]> wrote: Hi, I'm having a touch situation on my hands. Last week one of my site was shut down in what the Hosting Company claimed to be a Policy Violation. However, it was found out later that it wasn't so and they had to re-host my site. Unfortunately, they erased my mySQL database with my account and we lost all our very important Data in the tables there. It's horrible. We're beggining again but i'm not scared about the Data. The data is posted online by users. I need to have a way to backup my mySQL data. If possible, on some other site location or in Hard Copy (As in a file) or something. I don't know how to do any of this. I have no idea what to do about it. Can anyone make any suggestions & help? Regards, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] Mehmet Erisen http://www.erisen.com - Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctionsfor all of your holiday gifts!
RE: [PHP] How to backup records in mySQL DB?
Personnaly i use this method with phpMyAdmin. I make a dump of each table Structure and data.copy and paste it into a txt file. You can also use de csv format. Hope you don't hae a lot of table :=) I know it's very simple but it work. -Message d'origine- De : Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 20 décembre 2001 08:28 À : [EMAIL PROTECTED] Objet : [PHP] How to backup records in mySQL DB? Hi, I'm having a touch situation on my hands. Last week one of my site was shut down in what the Hosting Company claimed to be a Policy Violation. However, it was found out later that it wasn't so and they had to re-host my site. Unfortunately, they erased my mySQL database with my account and we lost all our very important Data in the tables there. It's horrible. We're beggining again but i'm not scared about the Data. The data is posted online by users. I need to have a way to backup my mySQL data. If possible, on some other site location or in Hard Copy (As in a file) or something. I don't know how to do any of this. I have no idea what to do about it. Can anyone make any suggestions & help? Regards, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]