Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1449
  • Last Modified:

Restoring a SQL database

I have a fellow co-worker who I have been helping out with some projects.  I have setup and configured a cacti server for them using fedora, mysql, cacti, php5, etc...

It is all working well but now he wants me to use an old DB file he had saved from his last cacti server to restore to the new database.  It is a six meg text file and phpMyAdmin will not let me import anything larger than 2.4 megs.

I know there has to be a way to restore this, can anyone help?  I have very little mysql knowledge.

Thanks
0
savone
Asked:
savone
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you should import that from the command line, using the mysql command line tool.

mysql <connection options>   < yourfile.sql
0
 
savoneAuthor Commented:
Go it... Thanks...

I used mysql -u root -p cacti < cacti_bu.sql

cacti being my database name and cacti_bu.sql being the backup file.

0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now