restore database

Restore a backup of a MySQL Database Server

by Vivek Gite on November 10, 2007 · 2 comments

Q. How can I restore a backup of a MySQL database server made with mysqldump program discussed here? A. You can use standard mysql – the MySQL command-line tool to restore a backup of a MySQL database server. Read back dump file You can read the dump file back into the server like this: mysql [...]

{ 2 comments }

Import MySQL Dumpfile, SQL Datafile Into My Database

by Vivek Gite on August 23, 2006 · 53 comments

How can I import a MySQL dumpfile into my database? I’m using CentOS Linux 5 server. My old hosting provider gave me a data.sql file and I do have access to my Unix / Linux server via ssh. So How do I restore my data using command line over the ssh session?

{ 53 comments }