• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1451
  • 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.

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
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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