SQL Database from a text file

[Bruce]

How does one produce an SQL DB from a text file? Here's the file.

[Dermot]

That's a MySQL dump file created with phpMyAdmin. You can recreated the db by importing this file using phpMyAdmin or any other MySQL management program.

[RizlaUK]

yup, just paste it in to phpMyAdmin "Execute SQL" or import the file and away you go

[AGRO]

Sorry, already answered.

[cooollingesh]

How to generate text file from sql database

[RizlaUK]

in phpmyadmin, select your database and click "EXPORT"

[longedge]

How to generate text file from sql database

Is that sql or is it mysql?

[Bruce]

SQL...I really didn't want to load that whole phpmyadmin onto a server just to make that DB. Is there another way? (easy/er)

[RizlaUK]

Is there another way?

yeah......do it in php,

is that the database ^^ in your first post....i'll make a start for you

[longedge]

SQL...I really didn't want to load that whole phpmyadmin onto a server just to make that DB. Is there another way? (easy/er)

Looks to me like your text file is a mysql dump. If you have access to the mysql database and a sql server then you'd probably be looking at creating a dts (data transformation services) package on the sql database. It's most definitely not for the faint-hearted. I scratch at the surface of sql server every day but only because I have to, I wouldn't fancy doing/trying it.

Stick with mysql and mysqladmin would be my advice fwiw.

I would have thought that your ISP could help you out with this. If it isn't already available, ask them if they will install it.

Take Rizla up on his offer

[RizlaUK]

Hey Bruce, run this php file in your browser to install the tables

just edit the connection stuff at the top

[Bruce]

Thanks RizlaUK-
It wont open for me, thank you for trying.