Programming Forums

Programming Forums (http://www.programmingforums.org/forumindex.php)

- Other Web Development Languages (http://www.programmingforums.org/forum40.html)

- - MySql (http://www.programmingforums.org/showthread.php?t=12535)

paulchwd

Feb 8th, 2007 5:12 PM

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

PhilBon

Feb 8th, 2007 6: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 7: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 7: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 8:08 PM

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

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 8: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 8:33 PM

What gui does your hosting provider provide for you?

PhilBon

Feb 8th, 2007 9: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 10:17 PM

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

All times are GMT -5. The time now is 1:50 AM.