XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Which settings to use then backup database through phpmyadmin?
Register
1
hipoonios
Which settings to use then backup database through phpmyadmin?

I need to export my database so I can import it to my new server. Is there something special to think about? Also the new server have Php5 and mysql5 (old one php4/mysql4).

I'm unsure which settings to use here. I want to be sure before starting.

I mean these settings: Add DROP TABLE, ADD IF NOT EXISTS etc..
(http://www.sugarcrm.com/wiki/images/8/8e/Phpmyadmin_backup.png)
I love Xoops!
2
ghia
Re: Which settings to use then backup database through phpmyadmin?

  • 2009/6/6 9:12

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Your settings are OK. (I would prefer to zip)
The XOOPS version needs to be the same.
If the domainname changes, you may need to do some replacements first.
3
Anonymous
Re: Which settings to use then backup database through phpmyadmin?

  • 2009/6/6 13:29

  • Anonymous

  • Posts: 0

  • Since:


Hi,

You need to select the database tables ("Select All").

In addition to those items that you've already checked, I also check "Complete inserts" and "Extended inserts".

As Ghia says, use compression. I prefer "gzip" but which you use is up to you.
4
anderssk
Re: Which settings to use then backup database through phpmyadmin?

  • 2009/6/6 19:47

  • anderssk

  • Quite a regular

  • Posts: 335

  • Since: 2006/3/21


Ghia@ It's not a XOOPS installation he is backing up - but the princip is the same.

hipoonios@ What's the story? Why ask in XOOPS (we love to help?)

Now I see the signature with the xoops-sites

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

174 user(s) are online (89 user(s) are browsing Support Forums)

Members: 0

Guests: 174

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits