subject:"RE\: AM software \(access dump\) and GUI"

RE: AM software (access dump) and GUI

2004-08-09 Thread Victor Pendleton

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=softwareDETAIL
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]

Re: AM software (access dump) and GUI

2004-08-09 Thread EWA Goodson Wickes

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=softwareDETAIL
 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]

Re: AM software (access dump) and GUI

2004-08-09 Thread Daniel Lahey

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=softwareDETAIL
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]

RE: AM software (access dump) and GUI

2004-08-09 Thread Sunmaia

phpMyAdmin will display a create database box on the initial page, if you
have the rights to create databases. If you don't have the right, then it
wont.

Often hosting plans have their own programming for creating databases
because of the problems of making sure you cannot mess with other peoples
databases.

HTH

Peter


 -Original Message-
 From: Daniel Lahey [mailto:[EMAIL PROTECTED]
 Sent: 10 August 2004 00:44
 To: [EMAIL PROTECTED]
 Subject: Re: AM software (access dump) and GUI


 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=softwareDETAIL
  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]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: AM software (access dump) and GUI

Re: AM software (access dump) and GUI

Re: AM software (access dump) and GUI

RE: AM software (access dump) and GUI

4 matches

Site Navigation

Mail list logo

Footer information