Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

[PHP-DB] Restore database from a dump From: Russell Griechen (russgri <email protected>)
Date: 09/13/02

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php