Forums | Mahara Community

Support /
My mysql database is completely empty? Postgres problem!


anonymous profile picture
Account deleted
Posts: 23

14 June 2011, 4:01

I was just checking through my backups before updating to 1.4 and noticed that my mahara mysql database is completely empty with no tables or records?

 

then I realised that I am using postgres!

 

Can anyone let me know how I can see or backup a postgres database as I am used to mysql!

 

I have it linked to my moodle site but surely I should have something?

 

Can anyone help?

 

thanks

anonymous profile picture
Account deleted
Posts: 23

14 June 2011, 7:44

I found the command to get to phppgadmin and that sorted me out!

anonymous profile picture
Account deleted
Posts: 214

14 June 2011, 7:50

Hi Reg,

Without knowing what Operating System you're using, or what access you have (e.g. cpanel), it's difficult to know what the best method is for you. That said, if you're running a Linux-based system, then your best option is to use pg_backup.

You should be able to do so relatively easily with a cron job, running as your postgres user (e.g postgres) and dumping to a file.

In Mahara, we far prefer Postgresql over MySQL for a whole host reasons.

anonymous profile picture
Account deleted
Posts: 23

14 June 2011, 8:36

Hi Andrew, I used pg_backup in the end and everything is happy now!

 

Thanks

4 results