<div>
Go it... Thanks...<br />
<br />
I used mysql -u root -p cacti &lt;&nbsp;cacti_bu.sql<br />
<br />
cacti being my database name and cacti_bu.sql being the backup file.<br />
<br />

</div>


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.



<div>
<div class="content wysiwyg-content">
I have a fellow co-worker who I have been helping out with some projects. &nbsp;I have setup and configured a cacti server for them using fedora, mysql, cacti, php5, etc...<br />
<br />
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. &nbsp;It is a six meg text file and phpMyAdmin will not let me import anything larger than 2.4 megs.<br />
<br />
I know there has to be a way to restore this, can anyone help? &nbsp;I have very little mysql knowledge.<br />
<br />
Thanks<br />

</div>
</div>


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


Restoring a SQL database

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.