PDA

View Full Version : Database backup


JC Olsen
01-02-2006, 09:06 AM
Hello hello

I'm about to do a full backup before I do the 1.5 beta 1 upgrade. Though I am unsure what to check off under EXPORT in phpMyAdmin to make a correct database backup for pixelpost. WordPress have a very nice short litle guide on how to backup the database correct (http://codex.wordpress.org/Backing_Up_Your_Database) for their blog. Do something like that exist for PP? If no I'd like to request one :)

Will has asked me to do some stuff so I guess I need the latest version ;)

Thanks

Connie
01-02-2006, 09:35 AM
Hello as well!

First a happy New Year!
And welcome here, didn't see you for long time!

Currently we have no tutorial / help / readme for database backup, but it's a good suggestion !

As we plan to concentrate on usability, information, pixelpost.org, faq after releasing 1.5 Final, this for sure will be a topic for the faq and our readme-files.

Please do a complete backup of these tables:

{PREFIX_IFTHERE}config
{PREFIX_IFTHERE}categories
{PREFIX_IFTHERE}pixelpost
{PREFIX_IFTHERE}comments
{PREFIX_IFTHERE}visitors
{PREFIX_IFTHERE}version
{PREFIX_IFTHERE}catassoc

JC Olsen
01-02-2006, 09:41 AM
Happy new year :)

Been busy ;) Hoping to put a little into PP now soon as mentioned. By starters upgrading my old language files for you and such.

I'll try be more spesific by putting up this screenshot. I do not know what to click there in order to make the full backup hehe ;) Too many buttons eh? :P

http://www.jcolsen.com/random/phpmyadmin.jpg

so.. what do I click on? :o

eon
01-02-2006, 10:27 AM
When I backup a db I use these settings:

http://tweakers.net/ext/f/37dc5380ff426ca6c5612f45c50312b5/full.png

Export --> select all and SQL. Leave the rest as it is.
What you get is a textpage, I copy/past this text in a document and save it.
The text is like one big SQL query.
This works for me. I use it one time when I changed from server.

Example:

http://tweakers.net/ext/f/1998a9b7ae8967208a78aff1f44d414b/full.png

JC Olsen
01-02-2006, 10:32 AM
Great thanks a lot :D