Restore database from a dump

From: 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

« previous php.db (#21749) next »