Restore database from a dump
| From: | Russell Griechen | Date: | Sat, 14 Sep 2002 02:04:24 +0000 |
| Subject: | Restore database from a dump | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21749@lists.php.net to get a copy of this message | ||
I am using PhpMyAdmin
To restore a mysql database from a dump:
(this is one command line!)
/usr/local/mysql/bin/mysql databasename -u username -p**** <
/home/username/file.dump
Question:
What is the proper syntax...I assume that I copy this dump file to the
Query window and Go?
Here is a dump:
# phpMyAdmin MySQL-Dump
# version 2.2.0
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download
page)
#
# Host: localhost
# Generation Time: September 11, 2002, 1:50 pm
# Server version: 3.23.49
# PHP Version: 4.2.1
# Database :
sportsmen
# --------------------------------------------------------
#
# Table structure for table nuke_admin_menu
#
CREATE TABLE nuke_admin_menu (
pn_amid int(10) unsigned NOT NULL auto_increment,
Russell Griechen