php-db | 2002091
Date: 09/13/02
- Next message: Pierre-Alain Joye: "Re: [PHP-DB] Restore database from a dump"
- Previous message: Barry Rumsey: "[PHP-DB] joining tables"
- In reply to: Barry Rumsey: "[PHP-DB] joining tables"
- Next in thread: Pierre-Alain Joye: "Re: [PHP-DB] Restore database from a dump"
- Reply: Pierre-Alain Joye: "Re: [PHP-DB] Restore database from a dump"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Pierre-Alain Joye: "Re: [PHP-DB] Restore database from a dump"
- Previous message: Barry Rumsey: "[PHP-DB] joining tables"
- In reply to: Barry Rumsey: "[PHP-DB] joining tables"
- Next in thread: Pierre-Alain Joye: "Re: [PHP-DB] Restore database from a dump"
- Reply: Pierre-Alain Joye: "Re: [PHP-DB] Restore database from a dump"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

