Programming Forums > Web Development and Design > Other Web Development Languages

paulchwd · Feb 8th, 2007, 4:12 PM

I am used to working with Access, where I create the database and tables in access and then do everything else via ASP code that i wrote, I need do do some work with a MySQL and host it, now im not in control of the servers its being hosted on all i have is ftp access

I have used MySQL on my desktop but not much

Question: does MySql produce a file for the DB that I can upload to my webserver like Access?

Or

Does MySQl have to be installed on the webserver and i have to interact with it that way.

Thanks

PhilBon · Feb 8th, 2007, 5:32 PM

MySQL is like Microsoft SQL Server but less complicated as well as open source. It is a service so it has to be installed onto the server in order for it to run. You must also have a Mod to work in between the Coding and the Database itself. So to answer your question, no MySQL does not produce a file that you can upload. The database itself is contained in file(s) but you can't access them directly, at least that's what I know.

DaWei · Feb 8th, 2007, 6:00 PM

Your server probably provides you with an administration package (PhPMyAdmin is an example). You can describe the database with files and upload/download them.

paulchwd · Feb 8th, 2007, 6:17 PM

thanks for the replies,

DaWei, what do you mean by "you can describe the database with files"

My server has a GUI for me to interafce with MySQL but i want the cmd line.

Arevos · Feb 8th, 2007, 7:08 PM

You can create tables and records in MySQL via SQL commands. For example:

 sql Syntax (Toggle Plain Text) 
CREATE TABLE pets (
    id int,
    species varchar(100),
    name varchar(100)
);
 
INSERT INTO pets (species, name) VALUES ('dog', 'rover')
INSERT INTO pets (species, name) VALUES ('cat', 'fluffy')
CREATE TABLE pets (
    id int,
    species varchar(100),
    name varchar(100)
);

INSERT INTO pets (species, name) VALUES ('dog', 'rover')
INSERT INTO pets (species, name) VALUES ('cat', 'fluffy')

In MySQL and most other databases, a set of commands like this can be generated from an existing table that will recreate it exactly. This set of commands can be saved in a file, and imported into a remote database. This is what DaWei means by describing the database with files.

paulchwd · Feb 8th, 2007, 7:29 PM

oh...i didnt make the connection between the desc command and that

I know how to code Sql, but thank you.

My problem is that my hosting provider only has a gui interface to create tables / statements what not, i prefer command line and running my own scripts.

thank all of you:

Do you know of any program i can use to connect to the database command lie remotely, i had used Oracle before (throgh school) and we used sql plus to use to oracle

big_k105 · Feb 8th, 2007, 7:33 PM

What gui does your hosting provider provide for you?

PhilBon · Feb 8th, 2007, 8:48 PM

There is a program and I can't remember it's name but it's at the MySQL website and it's a remote way to do the command line (I Believe) if not you can create tables remotely. You might have to set the server to accept connections from your computer in order for it to work though.

paulchwd · Feb 8th, 2007, 9:17 PM

sounds nice, just like what i want, i will look into that thanks

Feb 8th, 2007, 4:12 PM	#1
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	MySql I am used to working with Access, where I create the database and tables in access and then do everything else via ASP code that i wrote, I need do do some work with a MySQL and host it, now im not in control of the servers its being hosted on all i have is ftp access I have used MySQL on my desktop but not much Question: does MySql produce a file for the DB that I can upload to my webserver like Access? Or Does MySQl have to be installed on the webserver and i have to interact with it that way. Thanks

Feb 8th, 2007, 6:00 PM	#3
DaWei Resident Grouch Join Date: Jun 2005 Posts: 6,453 Rep Power: 10	Your server probably provides you with an administration package (PhPMyAdmin is an example). You can describe the database with files and upload/download them. __________________ Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code. Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Feb 8th, 2007, 7:08 PM	#5
Arevos Programming Guru Join Date: Aug 2005 Location: England Posts: 1,499 Rep Power: 4	You can create tables and records in MySQL via SQL commands. For example: sql Syntax (Toggle Plain Text) CREATE TABLE pets ( id int, species varchar(100), name varchar(100) ); INSERT INTO pets (species, name) VALUES ('dog', 'rover') INSERT INTO pets (species, name) VALUES ('cat', 'fluffy') CREATE TABLE pets ( id int, species varchar(100), name varchar(100) ); INSERT INTO pets (species, name) VALUES ('dog', 'rover') INSERT INTO pets (species, name) VALUES ('cat', 'fluffy') In MySQL and most other databases, a set of commands like this can be generated from an existing table that will recreate it exactly. This set of commands can be saved in a file, and imported into a remote database. This is what DaWei means by describing the database with files.

Feb 8th, 2007, 7:33 PM	#7
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,623 Rep Power: 10	What gui does your hosting provider provide for you? __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 8th, 2007, 5:32 PM	#2
PhilBon Hobbyist Programmer Join Date: Nov 2005 Posts: 171 Rep Power: 3	MySQL is like Microsoft SQL Server but less complicated as well as open source. It is a service so it has to be installed onto the server in order for it to run. You must also have a Mod to work in between the Coding and the Database itself. So to answer your question, no MySQL does not produce a file that you can upload. The database itself is contained in file(s) but you can't access them directly, at least that's what I know.

Feb 8th, 2007, 6:17 PM	#4
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	thanks for the replies, DaWei, what do you mean by "you can describe the database with files" My server has a GUI for me to interafce with MySQL but i want the cmd line.

Feb 8th, 2007, 7:29 PM	#6
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	oh...i didnt make the connection between the desc command and that I know how to code Sql, but thank you. My problem is that my hosting provider only has a gui interface to create tables / statements what not, i prefer command line and running my own scripts. thank all of you: Do you know of any program i can use to connect to the database command lie remotely, i had used Oracle before (throgh school) and we used sql plus to use to oracle

Feb 8th, 2007, 8:48 PM	#8
PhilBon Hobbyist Programmer Join Date: Nov 2005 Posts: 171 Rep Power: 3	There is a program and I can't remember it's name but it's at the MySQL website and it's a remote way to do the command line (I Believe) if not you can create tables remotely. You might have to set the server to accept connections from your computer in order for it to work though.

Feb 8th, 2007, 9:17 PM	#9
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	sounds nice, just like what i want, i will look into that thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Syncing MySQL	drumltd	PHP	3	Nov 2nd, 2006 5:10 PM
MySQL with python?	snipertomcat	Python	2	Apr 13th, 2006 1:34 AM
Tutorial - Using MySQL in C#	Darkhack	C#	12	Jan 17th, 2006 9:28 AM
Simple Perl / MySQL Problem.. pls help!	domquemo	Perl	0	Jan 11th, 2006 4:08 AM
More MySQL errors	ArchAngel	PHP	12	Mar 8th, 2005 9:53 PM