Re: backing up mysql database (mysqldump)
Uri Evenhen More wrote: Hi Friends, I am hosting my website on Servage.net, where I don't get SSH access. I need to run mysqldump in order to backup my mysql database to SQL format (I need the backup in SQL format). Is there a way to run mysqldump without using SSH access? Does phpmyadmin support this? Yes - login to phpmyadmin, choose DB, then click on the export tab (while still viewing the DB, not a specific table). Choose your export preferences and go. They also have cron scripts enabled - can I put such a command in my cron job? Please help. Thanks, Uri Evenhen More (Ore) Mobile Phone: +972-50-9007559 E-mail: [EMAIL PROTECTED] Blog: http://www.speedy.net/uri/blog/ Now working on version l.l of the pie - defined as o/o or olo or lol. I discovered the number of dots is very important - l..l is not equal to l.l; and l is not equal to l. I am working on dividing your numbers and numbering your primes. it's very complicated, since every number can be considered prime, not prime, integer and irrational. remember there is at least one more root to every equation than what you previously thought, for example there are at least pie square roots of the number pie. Update: moved my blog to http://www.speedy.net/uri/blog/ . I decided to remove other content from this website. [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] - This message is confidential - [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED] = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
backing up mysql database (mysqldump)
Hi Friends, I am hosting my website on Servage.net, where I don't get SSH access. I need to run mysqldump in order to backup my mysql database to SQL format (I need the backup in SQL format). Is there a way to run mysqldump without using SSH access? Does phpmyadmin support this? They also have cron scripts enabled - can I put such a command in my cron job? Please help. Thanks, Uri Evenhen More (Ore) Mobile Phone: +972-50-9007559 E-mail: [EMAIL PROTECTED] Blog: http://www.speedy.net/uri/blog/ Now working on version l.l of the pie - defined as o/o or olo or lol. I discovered the number of dots is very important - l..l is not equal to l.l; and l is not equal to l. I am working on dividing your numbers and numbering your primes. it's very complicated, since every number can be considered prime, not prime, integer and irrational. remember there is at least one more root to every equation than what you previously thought, for example there are at least pie square roots of the number pie. Update: moved my blog to http://www.speedy.net/uri/blog/ . I decided to remove other content from this website. [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] - This message is confidential - [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
Re: backing up mysql database (mysqldump)
You can upload a script file that does it for you (a cgi for example) and it will react only to your IP address (for security) reasons. If you can upload and execute such script, then there is no problem doing so, if you can't the, crontab can help you with a script that does it. Ido On Sun, Nov 30, 2008 at 9:03 PM, Uri Evenhen More [EMAIL PROTECTED] wrote: Hi Friends, I am hosting my website on Servage.net, where I don't get SSH access. I need to run mysqldump in order to backup my mysql database to SQL format (I need the backup in SQL format). Is there a way to run mysqldump without using SSH access? Does phpmyadmin support this? They also have cron scripts enabled - can I put such a command in my cron job? Please help. Thanks, Uri Evenhen More (Ore) Mobile Phone: +972-50-9007559 E-mail: [EMAIL PROTECTED] Blog: http://www.speedy.net/uri/blog/ Now working on version l.l of the pie - defined as o/o or olo or lol. I discovered the number of dots is very important - l..l is not equal to l.l; and l is not equal to l. I am working on dividing your numbers and numbering your primes. it's very complicated, since every number can be considered prime, not prime, integer and irrational. remember there is at least one more root to every equation than what you previously thought, for example there are at least pie square roots of the number pie. Update: moved my blog to http://www.speedy.net/uri/blog/ . I decided to remove other content from this website. [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] - This message is confidential - [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
Re: backing up mysql database (mysqldump)
Hi. have you tried using the -h switch? mysqldump -h x.x.x.x should let you connect to the mysql server on IP x.x.x.x but dump it locally. good luck, Mike Uri Evenhen More wrote: Hi Friends, I am hosting my website on Servage.net, where I don't get SSH access. I need to run mysqldump in order to backup my mysql database to SQL format (I need the backup in SQL format). Is there a way to run mysqldump without using SSH access? Does phpmyadmin support this? They also have cron scripts enabled - can I put such a command in my cron job? Please help. Thanks, Uri Evenhen More (Ore) Mobile Phone: +972-50-9007559 E-mail: [EMAIL PROTECTED] Blog: http://www.speedy.net/uri/blog/ Now working on version l.l of the pie - defined as o/o or olo or lol. I discovered the number of dots is very important - l..l is not equal to l.l; and l is not equal to l. I am working on dividing your numbers and numbering your primes. it's very complicated, since every number can be considered prime, not prime, integer and irrational. remember there is at least one more root to every equation than what you previously thought, for example there are at least pie square roots of the number pie. Update: moved my blog to http://www.speedy.net/uri/blog/ . I decided to remove other content from this website. [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] - This message is confidential - [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED] = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
Re: backing up mysql database (mysqldump)
1. phpMyAdmin can do dumps, but not automatically IIRC. 2. you can put a dump command in your crontab, and then another one that uploads the resulting file by ftp somewhere. but then you'll also have to set a .netrc and i don't know if you can do that on your server. 3. easiest thing - just create a web script (with proper authentication) that dumps your db to the browser (e.g. ?php if ($_GET['p'] = 'my_strong_password') system(mysqldump bla bla); ?), then call it from your backup machine in a cron job with wget. put it under https if you really want to be secure. On Sun, Nov 30, 2008 at 9:03 PM, Uri Evenhen More [EMAIL PROTECTED] wrote: Hi Friends, I am hosting my website on Servage.net, where I don't get SSH access. I need to run mysqldump in order to backup my mysql database to SQL format (I need the backup in SQL format). Is there a way to run mysqldump without using SSH access? Does phpmyadmin support this? They also have cron scripts enabled - can I put such a command in my cron job? Please help. Thanks, Uri Evenhen More (Ore) Mobile Phone: +972-50-9007559 E-mail: [EMAIL PROTECTED] Blog: http://www.speedy.net/uri/blog/ Now working on version l.l of the pie - defined as o/o or olo or lol. I discovered the number of dots is very important - l..l is not equal to l.l; and l is not equal to l. I am working on dividing your numbers and numbering your primes. it's very complicated, since every number can be considered prime, not prime, integer and irrational. remember there is at least one more root to every equation than what you previously thought, for example there are at least pie square roots of the number pie. Update: moved my blog to http://www.speedy.net/uri/blog/ . I decided to remove other content from this website. [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] - This message is confidential - [o-o-o-oo-o-o-o][o-o-o-oo-o-o-o] = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]