Can I do issue CREATE and DROP database commands with phpadmin? Our hosting paln has this Thanks a lot
----- Original Message ----- From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "'EWA Goodson Wickes '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 09, 2004 4:09 PM Subject: RE: AM software (access dump) and GUI > You can load the data by using the mysql command. > mysql -uuser -ppassword < fileToLoad.sql > ... > If you are on a shared database server I do not think you will be able to > issue the CREATE and DROP database commands. > > -----Original Message----- > From: EWA Goodson Wickes > To: [EMAIL PROTECTED] > Sent: 8/9/04 3:47 PM > Subject: AM software (access dump) and GUI > > Hi all, > I have just installed mysql on my pc and outside hosting with a > webhosting company. > I have an access db that I want to convert into mysql. I tried the > program > http://www.intranet2internet.com/public/default.asp?PAGE=software&DETAIL > S=A2M > to convert a tiny access db as a test. This I did and now I have a .sql > file which I have pasted below. This file I uploaded via ftp to our > hosting with hostdepartment.com > What do I do with this file? Upload it via ftp? Thanks a lot for any > help > DROP DATABASE temp_db1; > > CREATE DATABASE if not exists temp_db1; > > USE temp_db1; > > drop table Mailing_List; > > CREATE TABLE if not exists Mailing_List ( > > MailingListID INT AUTO_INCREMENT NOT NULL, > > FirstName CHAR(50), > > MiddleName CHAR(30), > > PRIMARY KEY ( MailingListID ) > > ); > > INSERT INTO Mailing_List VALUES ('1','ed','good'); > > INSERT INTO Mailing_List VALUES ('2','trev','wickes'); > > INSERT INTO Mailing_List VALUES ('3','ron','wickes'); > > > > > This I uploaded to my website. > phpAdmin control panel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
