Re: [RDD] DB restore

2014-02-21 Thread Wayne Merricks
MySQL command line should work: First make a new backup just in case it goes even more Pete Tong: mysqldump -u rduser -p Rivendell > ~/justincase.sql Then import the backup you want to use: mysql -u rduser -p Rivendell < /path/to/backup/file/mybackup.sql This will login to mysql on the local

Re: [RDD] DB restore

2014-02-21 Thread Cowboy
On Friday 21 February 2014 02:23:06 am Stan Fotinos wrote: > Have you tried using Mysql admin command line or  GUI to see what is > happening. You can also try using this to restore the database if > rdadmin wont do it. Personally, I use webmin for that sort of thing, but PhpMyAdmin can do it

Re: [RDD] DB restore

2014-02-20 Thread Stan Fotinos
Hi Gavin Have you tried using Mysql admin command line or GUI to see what is happening. You can also try using this to restore the database if rdadmin wont do it. Stan On 21/02/14 3:13 PM, Gavin Stephens wrote: I've managed to remove SQL and reinstall it but rdadmin still won't start prop

Re: [RDD] DB restore

2014-02-20 Thread Gavin Stephens
I've managed to remove SQL and reinstall it but rdadmin still won't start properly. I think he DB must still be left in the system somewhere? Sent from my iPod On 21/02/2014, at 19:45, Gavin Stephens wrote: > Man I really learnt how to screw up RD today. I renamed an event in > rdlogmanager w

Re: [RDD] DB restore

2014-02-20 Thread Gavin Stephens
Sorry silly autocorrect on my iPod. Nothing RD will start cause the DB is had it. The backups good and the many before it, but I can't restore because between the restore and the DB in SQL it's all gone haywire and rdadmin refuses to do anything other than choke the CPU without coming up. Sen

[RDD] DB restore

2014-02-20 Thread Gavin Stephens
Man I really learnt how to screw up RD today. I renamed an event in rdlogmanager without removing it from a clock. The. I lost all the events in y clock bar about 2-3. So I figured I'll just launch rdamin and do a DB restore. Only it froze trying to a restore from a perfectly valid backup. Now