MySQL4.0から5.0へ移行する手順
C:\mysql\bin>mysqldump -u root -p rensyu >c:\rensyu.sql
Enter password: ******
C:\mysql\bin>cd "\Program Files\MySQL\MySQL Server 5.0\bin
※注 MySQL4.0→MySQL5.0にサービスを変更
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE rensyu;
Query OK, 1 row affected (0.00 sec)
mysql> USE rensyu
Database changed
mysql> SOURCE C:\\rensyu.sql
Query OK, 0 rows affected, 1 warning (0.06 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.09 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.05 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 0 rows affected, 1 warning (0.08 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.09 sec)
Query OK, 1 row affected (0.05 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
mysql> GRANT ALL PRIVILEGES ON rensyu.* TO ideg@192.168.1.2
-> IDENTIFIED BY 'create';
Query OK, 0 rows affected (0.00 sec)
mysql>rensyu.sqlの内容
-- MySQL dump 9.11
--
-- Host: localhost Database: rensyu
-- ------------------------------------------------------
-- Server version 4.0.26-nt
--
-- Table structure for table `members`
--
CREATE TABLE members (
id int(10) unsigned NOT NULL auto_increment,
name varchar(40) NOT NULL default '',
fname varchar(40) NOT NULL default '',
secdist tinyint(3) unsigned NOT NULL default '0',
zipcode varchar(7) NOT NULL default '',
add1 varchar(60) NOT NULL default '',
add2 varchar(60) NOT NULL default '',
tel varchar(13) NOT NULL default '',
fax varchar(13) NOT NULL default '',
email varchar(50) NOT NULL default '',
ktai varchar(13) NOT NULL default '',
nyear year(4) NOT NULL default '0000',
PRIMARY KEY (id),
KEY Index_2 (nyear)
) TYPE=MyISAM;
--
-- Dumping data for table `members`
--
INSERT INTO members VALUES (1,'日経ソフトウェア','ニッケイソフトウェア',0,'9999999','千代田区平河町','2-1-1','03-****-++++','03-****-****','nsw@***.com','090-+++-****',2005);
INSERT INTO members VALUES (2,'山田太郎','ヤマダタロウ',0,'9999999','東京都港区','','03-0000-0000','','','090-9876-5432',2006);
--
-- Table structure for table `t_hanbai`
--
CREATE TABLE t_hanbai (
id int(10) unsigned NOT NULL auto_increment,
ndate date NOT NULL default '0000-00-00',
tkcd char(4) NOT NULL default '',
shcd char(6) NOT NULL default '',
suryo smallint(6) NOT NULL default '0',
kkbun char(1) NOT NULL default '1',
PRIMARY KEY (id),
KEY tkcd (tkcd),
KEY shcd (shcd),
KEY ndate (ndate),
KEY kkbun (kkbun)
) TYPE=InnoDB;
--
-- Dumping data for table `t_hanbai`
--
INSERT INTO t_hanbai VALUES (1,'2005-07-11','1001','100001',10,'2');
INSERT INTO t_hanbai VALUES (2,'2005-07-12','1001','100101',3,'1');
INSERT INTO t_hanbai VALUES (3,'2005-07-12','1002','100201',47,'2');
INSERT INTO t_hanbai VALUES (4,'2005-07-21','1003','100A01',14,'3');
INSERT INTO t_hanbai VALUES (5,'2005-07-22','1005','100B01',4,'3');
INSERT INTO t_hanbai VALUES (6,'2005-08-01','1002','100202',16,'1');
INSERT INTO t_hanbai VALUES (7,'2005-08-02','1003','100203',17,'1');
INSERT INTO t_hanbai VALUES (8,'2005-08-02','1005','100C01',2,'3');
INSERT INTO t_hanbai VALUES (9,'2005-08-10','1001','100001',5,'2');
--
-- Table structure for table `t_syohin`
--
CREATE TABLE t_syohin (
shcd varchar(6) NOT NULL default '',
shname varchar(40) NOT NULL default '',
kigou varchar(4) NOT NULL default '',
tanka int(10) unsigned NOT NULL default '0',
zaikosu int(11) NOT NULL default '0',
PRIMARY KEY (shcd),
KEY kigou (kigou),
KEY tanka (tanka)
) TYPE=InnoDB;
--
-- Dumping data for table `t_syohin`
--
INSERT INTO t_syohin VALUES ('100001','USBメモリー128','USBM',2500,95);
INSERT INTO t_syohin VALUES ('100002','USBメモリー256','USBM',3500,100);
INSERT INTO t_syohin VALUES ('100003','USBメモリー512','USBM',5000,100);
INSERT INTO t_syohin VALUES ('100101','SDメモリーカード128','SDMC',2300,100);
INSERT INTO t_syohin VALUES ('100102','SDメモリーカード256','SDMC',4900,100);
INSERT INTO t_syohin VALUES ('100103','SDメモリーカード512','SDMC',5400,100);
INSERT INTO t_syohin VALUES ('100201','スマートメディア32','SM',1200,100);
INSERT INTO t_syohin VALUES ('100202','スマートメディア64','SM',2500,100);
INSERT INTO t_syohin VALUES ('100203','スマートメディア128','SM',5400,100);
INSERT INTO t_syohin VALUES ('100C01','コンパクトフラッシュ','1GCF',8200,100);
INSERT INTO t_syohin VALUES ('100C02','コンパクトフラッシュ2G','CF',18000,100);
--
-- Table structure for table `t_tokui`
--
CREATE TABLE t_tokui (
tkcd varchar(4) NOT NULL default '',
tkname varchar(40) NOT NULL default '',
PRIMARY KEY (tkcd)
) TYPE=InnoDB;
--
-- Dumping data for table `t_tokui`
--
INSERT INTO t_tokui VALUES ('1001','得意先名1');
INSERT INTO t_tokui VALUES ('1002','得意先名2');
INSERT INTO t_tokui VALUES ('1003','得意先名3');
INSERT INTO t_tokui VALUES ('1004','得意先名4');
INSERT INTO t_tokui VALUES ('1005','得意先名5');
