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. Installation Troubleshooting 
  4.  / How do I backup and restore mySQL database
Register
1
cchcla
How do I backup and restore mySQL database

  • 2003/10/2 23:37

  • cchcla

  • Just popping in

  • Posts: 10

  • Since: 2003/5/14


Hi, I need to upgrade the IPB module. Before I do that, I like to backup my database. If the upgrade fail, then I can restore my original database. Can anymore tell/show me how to create a backup database and later on restore it ?
2
anggarda
Re: How do I backup and restore mySQL database

  • 2003/10/3 3:22

  • anggarda

  • Just popping in

  • Posts: 59

  • Since: 2003/3/19


Simplest way.
Backup

mysqldump -uUSERNAME -pPASSWORD > BACKUPFILE.SQL

Restore

mysql -uUSERNAME -pPASSWORD DATABASENAME < BACKUPFILE.SQL

Do give it a trial run first and attempt to restore your DB to a parallel database to check that the binary datatypes were backup right.

Regards.
3
tjnemez
Re: How do I backup and restore mySQL database

  • 2003/10/3 4:58

  • tjnemez

  • Home away from home

  • Posts: 1594

  • Since: 2003/9/21


there is also a module you can get called backup, check the module downloads on this site. i use it and its slick. it will backup your tables and data, then email it to you.

make sure this module is only visible to webmaster, so set the permissions in sys admin - groups.

cheers
4
Ace_Armstrong
Re: How do I backup and restore mySQL database

Quote:

tjnemez wrote:
there is also a module you can get called backup, check the module downloads on this site. i use it and its slick. it will backup your tables and data, then email it to you.

make sure this module is only visible to webmaster, so set the permissions in sys admin - groups.

cheers


Do you know which options are appropriate for the downloads? There are several, and as an SQL idiot, I don't know which ones to pick.
5
bobdt
Re: How do I backup and restore mySQL database

  • 2003/10/11 20:26

  • bobdt

  • Just popping in

  • Posts: 38

  • Since: 2003/9/11


I think the best way is use phpmyadmin...
step A
1) Install it...
2) select the db of your XOOPS portal
3) click over export
4) select all table
5) then select "save with name"
6) save the file .SQL created

step B
save all the file of your old XOOPS (but realy is important only the mainfile)

ok now you have your portal in safe into of your Hd.

for restore it reinstall XOOPS and make restore with phpmyadmin... (click over SQL) then select the file from your hd and it will give to you all your old portal in new server.

Bob

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

190 user(s) are online (130 user(s) are browsing Support Forums)

Members: 0

Guests: 190

more...

Donat-O-Meter

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

Latest GitHub Commits