Hi All
I'm looking for a tool that will take a flatfile, delimited db and convert it into the kind of file that has the mysql arguments in it, like a dump file, only to be used for uploads:
# Generated by MySQLMan 1.09 (http://gossamer-threads.com/scripts/)
# Host: localhost Database: fred_help
#--------------------------------------------------------
#
# Table structure for table 'users'
#
DROP TABLE IF EXISTS users;
CREATE TABLE users (
id smallint(5) unsigned DEFAULT '' NOT NULL auto_increment,
username varchar(30) ,
password varchar(30) ,
name varchar(50) ,
email varchar(50) ,
url varchar(50) ,
company varchar(50) ,
rkey varchar(5) ,
pending char(1) DEFAULT '' NOT NULL ,
active varchar(50) ,
acode varchar(50) ,
lcall varchar(255) DEFAULT '' NOT NULL ,
PRIMARY KEY (id)
);
#
# Dumping data for table 'users'
#
INSERT INTO users (id,username,password,name,email,url,company,rkey,pending,active,acode,lcall) VALUES('1','user','fredpass','User','user@fred.com','none','Company','FR','0','1016643228','0','1016631653');
INSERT INTO users (id,username,password,name,email,url,company,rkey,pending,active,acode,lcall) VALUES('2','user2','wilmapass','User2','user@wilma.com','none','Company','WI','0','0','0','0');
# ----------- Dump ends -----------
The reason I need this is that some hosts don't allow uploads of flatfile, delimited databases, but they do allow uploads of dump files.
So, I could still import a large db if I could put it in the above format efficiently, even if my host denies uploading flatfiles.
Many thanks for any help.
------------------------------------------
I'm looking for a tool that will take a flatfile, delimited db and convert it into the kind of file that has the mysql arguments in it, like a dump file, only to be used for uploads:
Quote:
# MySQL dump # Generated by MySQLMan 1.09 (http://gossamer-threads.com/scripts/)
# Host: localhost Database: fred_help
#--------------------------------------------------------
#
# Table structure for table 'users'
#
DROP TABLE IF EXISTS users;
CREATE TABLE users (
id smallint(5) unsigned DEFAULT '' NOT NULL auto_increment,
username varchar(30) ,
password varchar(30) ,
name varchar(50) ,
email varchar(50) ,
url varchar(50) ,
company varchar(50) ,
rkey varchar(5) ,
pending char(1) DEFAULT '' NOT NULL ,
active varchar(50) ,
acode varchar(50) ,
lcall varchar(255) DEFAULT '' NOT NULL ,
PRIMARY KEY (id)
);
#
# Dumping data for table 'users'
#
INSERT INTO users (id,username,password,name,email,url,company,rkey,pending,active,acode,lcall) VALUES('1','user','fredpass','User','user@fred.com','none','Company','FR','0','1016643228','0','1016631653');
INSERT INTO users (id,username,password,name,email,url,company,rkey,pending,active,acode,lcall) VALUES('2','user2','wilmapass','User2','user@wilma.com','none','Company','WI','0','0','0','0');
# ----------- Dump ends -----------
The reason I need this is that some hosts don't allow uploads of flatfile, delimited databases, but they do allow uploads of dump files.
So, I could still import a large db if I could put it in the above format efficiently, even if my host denies uploading flatfiles.
Many thanks for any help.
------------------------------------------