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.  / restroring a database
Register
1
kaliman
restroring a database

  • 2004/4/7 15:27

  • kaliman

  • Not too shy to talk

  • Posts: 110

  • Since: 2003/12/17


Hi
Does anyone knows the command to restore the database on linux?
I made a backup. But I cannot use phpmyadmin in this particular case, so any help would be appreciated.

Have a nice day!
2
Dave_L
Re: restroring a database

  • 2004/4/7 16:25

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


mysql -u USERNAME -p DBNAME < FILENAME.sql


That command will prompt for the password of user USERNAME, and then apply the MySQL commands in FILENAME.sql to database DBNAME.

This assumes that the database already exists and that USERNAME has the required grants.

If the database already contains tables, you might need to drop any tables in the database first, depending on whether FILENAME.sql contains drop-commands for any tables it creates.
3
kaliman
Re: restroring a database

  • 2004/4/7 16:41

  • kaliman

  • Not too shy to talk

  • Posts: 110

  • Since: 2003/12/17


Thank you, it worked perfect
4
romu
Re: restroring a database

  • 2004/4/7 17:19

  • romu

  • Theme Designer

  • Posts: 22

  • Since: 2002/12/5


FYI : u can also do through php scripts... for severe session configurations and no shell (main hosteds xoops).

I've found scripts that allow shedduled backup... in your mail and of course its reverse : a restore

db_backup
http://www.hotscripts.com/Detailed/27576.html

BigDump
http://www.hotscripts.com/Detailed/20922.html

Both scripts nice appreciated by my host... and documentation (french) at www.frxoops.org
5
svaha
Re: restroring a database

  • 2004/4/7 17:35

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Thnx Romu
6
kaliman
Re: restroring a database

  • 2004/4/7 18:06

  • kaliman

  • Not too shy to talk

  • Posts: 110

  • Since: 2003/12/17


Yes Thanks!
7
romu
Re: restroring a database

  • 2004/4/7 18:23

  • romu

  • Theme Designer

  • Posts: 22

  • Since: 2002/12/5


(bad) English news submited !

Best regards... and don't forget making it a xoops_addon...

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

246 user(s) are online (167 user(s) are browsing Support Forums)

Members: 0

Guests: 246

more...

Donat-O-Meter

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

Latest GitHub Commits