Quick mysql question..

GetDotted Domains

« Back To Forum Threads

Flip Order - Newest First | Show Avatars

The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.

Tue 07/12/04 at 21:01

Regular

"Picking a winner!"

Posts: 8,502

Right I'm sure this is possible and I'm sure I've done it before but I just can't remember how.

I have a whole load of info in a database, I'm setting up the database at uni now and want to create and populate the database at uni with the data I have.

Have an SQL file that will create all the tables and enter all the data into the tables.

Now I'm sure there is a command that can be entered that will execute the sql file and carry out all the commands it contains.

Anyone know how?

Wed 08/12/04 at 15:20

Regular

"Picking a winner!"

Posts: 8,502

Cheers

Will give it a try tomorrow.

Wed 08/12/04 at 10:34

Regular

"Lisan al-Gaib"

Posts: 7,093

"mysql db_name < text_file"

Easier to do in mysqladmin.

Tue 07/12/04 at 21:01

Regular

"Picking a winner!"

Posts: 8,502

Right I'm sure this is possible and I'm sure I've done it before but I just can't remember how.

I have a whole load of info in a database, I'm setting up the database at uni now and want to create and populate the database at uni with the data I have.

Have an SQL file that will create all the tables and enter all the data into the tables.

Now I'm sure there is a command that can be entered that will execute the sql file and carry out all the commands it contains.

Anyone know how?

Freeola & GetDotted are rated 5 Stars

Check out some of our customer reviews below:

Easy and free service!

I think it's fab that you provide an easy-to-follow service, and even better that it's free...!

Cerrie

Top-notch internet service

Excellent internet service and customer service. Top-notch in replying to my comments.

Duncan

View More Reviews

Find Us

Freeola & GetDotted
94 Church Street
Bocking
Braintree
Essex
CM7 5JY

Our Websites

About Us

Freeola is an ISP, offering unrivalled internet services to small businesses and consumers in the UK. We offer a range of services, from broadband to web hosting. Start at cheap domain name registration, get a free website, or just browse the site. Read more about Freeola & GetDotted.

View our Customer Reviews.

Join Our Mailing list

Join the Freeola & GetDotted mailing list for exclusive deals, offers and service updates straight to your email inbox.

It appears you are using an old browser, as such, some parts of the Freeola and Getdotted site will not work as intended. Using the latest version of your browser, or another browser such as Google Chrome, Mozilla Firefox, or Opera will provide a better, safer browsing experience for you.