Simple mysql tool?

[Josh Mellicker]

You could try CocoaMySQL on Mac:

http://cocoamysql.sourceforge.net/


Or, when our databases got too big to backup through a browser, I  
wrote a text script, ssh'ed into the server and popped it in the  
"daily" folder so it would run automatically every day:

mysqldump --user=db_username --password=swordfish --opt db_name > / 
home/acct_name/db_bus/db_name.dump
zip /home/acct_name/db_bus/db_name.$(date +%F).zip /home/dvcreato/ 
db_bus/db_name.dump

It is really cool, it creates a new backup file every day with the  
date on it.

The only caveat is that the backups will eventually eat up all the  
space on your server, so you need to download and delete them  
periodically!


Cheers

Josh


On Jul 30, 2006, at 11:01 PM, Esa Kivelä wrote:

> Greetings from Finland :)
>
> When my pc crashed some weeks ago I tried to look some handful mysq- 
> tools that I can simply get backups my phpp forums big database to  
> my Mac. In Windows I used that Mysql-Front wich is quite good program.
>
> Then I start thinking that hey RR also supports mysql so is that  
> possible to make some little application wich can export and import  
> databases?
>
> Before anyone says anything about Myphpbb Admin : I have tried that  
> and it don't support big databases in that server where I have my  
> forum :P.
>
> If someone can help me with this, please?
>
> Thanks at advance
>
> Yours
>
> Esa Kivela
>
>
>
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution