I am by no means a phpMyAdmin guru, but the version I have (2.5.7) has
an option for it, accessible by clicking on the "Databases" link from
the main page. I suspect, however, that they will give you a single
database that you will not have the DROP DATABASE privilege for and
that you will have to create all of your tables in a single database.
It seems like I've seen that specified on more than one hosting
service's description of their MySQL setup.
- Dan
On Aug 9, 2004, at 3:32 PM, EWA Goodson Wickes wrote:
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
