PHP SQL - Newbie SQL Question

Author

Newbie SQL Question

Hoops

2004-08-20, 4:33 am

I downloaded this program that will conver a .Mdb database to SQL.
However, once it's created I don't know how to get it to the SQL
server that I'm using. I can't FTP up there. Also, it has the SQL file
extension. I need to know how to display my Access database on a
webpage.

Nikolai Chuvakhin

2004-08-20, 3:56 pm

Hoops <Primster7@yahoo.com> wrote in message
news:<h1oai0ht4gekuui841pvhe5ovfescask15@4ax.com>...
>
> I downloaded this program that will conver a .Mdb database to SQL.
> However, once it's created I don't know how to get it to the SQL
> server that I'm using. I can't FTP up there. Also, it has the SQL file
> extension. I need to know how to display my Access database on a
> webpage.

Access is a desktop database management system; it uses a single file
to store both data and interface objects (forms, queries, reports, etc.)
Converting to an SQL server will only convert data. Interface will
be lost and will have to be developed anew (e.g., in PHP).

From your description, it seems that you have an SQL dump file, which
is a text file with a bunch of SQL statements inside. Something like
this:

CREATE TABLE `mytable` (
[field and index definitions here]
);
INSERT INTO `mytable` [insert instructions here];

If that is the case, you need to open the client program you are
using to access your SQL server and use that program to run all
the queries from the *.sql file. Open your *.sql file in a text
editor, copy its entire content to clipboard, and paste it into
the query editor of your SQL client. Then run the client, and
it will recreate your database on your remote server.

Now you can proceed to writing the new interface...

Cheers,
NC

steve

2004-08-21, 4:00 pm

"Nikolai Chuvakhin" wrote:
> Hoops <Primster7@yahoo.com> wrote in message
> news:<h1oai0ht4gekuui841pvhe5ovfescask15@4ax.com>...
> SQL.
> to the SQL
> has the SQL file
>
> Access is a desktop database management system; it uses a single
file
> to store both data and interface objects (forms, queries, reports,
> etc.)
> Converting to an SQL server will only convert data. Interface will

> be lost and will have to be developed anew (e.g., in PHP).
>
> From your description, it seems that you have an SQL dump file,
which
> is a text file with a bunch of SQL statements inside. Something
like
> this:
>
> CREATE TABLE `mytable` (
> [field and index definitions here]
> );
> INSERT INTO `mytable` [insert instructions here];
>
> If that is the case, you need to open the client program you are
> using to access your SQL server and use that program to run all
> the queries from the *.sql file. Open your *.sql file in a text
> editor, copy its entire content to clipboard, and paste it into
> the query editor of your SQL client. Then run the client, and
> it will recreate your database on your remote server.
>
> Now you can proceed to writing the new interface...
>
> Cheers,
> NC

If you have access to phpmyadmin, you can then execute this query
file. Just go to the query tab, and select the file on your disk, and
run it.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-SQL-New...pict141582.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=474852

Sponsored Links