DelphiFAQ Home Search:

How to run a *.sql script (mysql)

 

comments23 comments. Current rating: 1 stars (6 votes). Leave comments and/ or rate it.

Question:

I am installing a .php based tool, and one of the final instructions is to "Run the mysql.sql script to create the necessary tables in the database.". How to I achieve this?

Answer:

The *.sql file is a text file with SQL statements to be executed by the mysql server.

You can run it through a tool like phpMyAdmin - just open a query window there and copy and paste the content of that text file in there. phpMyAdmin and possibly other frontends will also allow to upload a *.sql file through the web browser. In phpMyAdmin click on the SQL tab.

If you don't have any such front end installed, you can also go to the shell (assuming you're on a Linux box here). If your site is hosted somewhere, you'll need putty (or a similar tool) to connect to the server.

Ftp your *.sql file to the (remote) machine if not done yet.

Execute this command and you'll be fine:

mysql <my_db_name> -u<user_name> -p<password> <mysql.sql


Content-type: text/html

Comments:

You are on page 2 of 2, other pages: 1 [2]
2014-11-29, 11:22:16
OJAS from United States  
Thanks Andrew. Reverse image links to pix stolen by a HE! NO GIRL @ the other end!
http://google.co.uk..348751.jpg
2014-11-29, 13:02:00
anonymous from Birmingham, United Kingdom  
OJAS. Thanks. Reverse image links to pix stolen by a HE! NO GIRL @ the other end!.. what are u talk about.. i dont know u
OJAS
2014-11-29, 15:26:40   (updated: 2014-11-29, 15:27:54)
Malek  
The meaning of Ojas,
There is no girl behind internet but more a guy. ( who pretend as a girl).
Regards
2014-12-20, 16:35:39
anonymous from Birmingham, United Kingdom  
rating
faith williams is a scam and want money so dont give it to her.. is no believe in her words and she will never show it or proivde it
her email adders is faith_williams69@yahoo.com

NO BELIEVE OR TRUST IS PEOPLE THAT ASKING FOR MONEY
SO PEOPLE IN THIS WORLD DONT BE ASK FOR MONEY FROM NO ONE ONLINE

now its over forever

This image was also posted here:
How to run a *.sql script (mysql)



Keywords:
2014-12-20, 16:35:39
anonymous from Birmingham, United Kingdom  
rating
faith williams is a scam and want money so dont give it to her.. is no believe in her words and she will never show it or proivde it
her email adders is faith_williams69@yahoo.com

NO BELIEVE OR TRUST IS PEOPLE THAT ASKING FOR MONEY
SO PEOPLE IN THIS WORLD DONT BE ASK FOR MONEY FROM NO ONE ONLINE

now its over forever

This image was also posted here:
How to run a *.sql script (mysql)



Keywords:
2015-01-30, 00:33:26
anonymous  
Man Interested Hi, i read your blog from time to time and i own a similar one and i was just wonidreng if you get a lot of spam responses? If so how do you prevent it, any plugin or anything you can advise? I get so much lately it's driving me insane so any help is
2015-07-06, 04:20:38
anonymous from United Kingdom  
I will not after sending my money to everyone in this world again. I have wasted 15'000pounds for someone to be here in the UK and I will not be hurt again.. If anyone asking me for money again I will not do it.. Other people need to pay where only bills and ticket.. I'm andrew peter cox from England Birmingham. DON'T SCAMS ME AGAIN IF YOU DO U WILL GO ON THIS SITE AND U WILL NOT BE COMING WHEN HERE TO A OTHER COUNTRIES FOR UR HOLIDAY'S. U WILP BE IN UR ONLY COUNTRY FOR THE REST OF U LIFE
2017-08-23, 01:36:44
anonymous from Indonesia  
kami sekeluarga tak lupa mengucapkan puji syukur kepada ALLAH S,W,T
dan terima kasih banyak kepada NYAI atas nomor togel.nya yang NYAI
berikan 4 angka 9050 alhamdulillah ternyata itu benar2 tembus NYAI.
dan alhamdulillah sekarang saya bisa melunasi semua utan2 saya yang
ada sama tetangga.dan juga BANK BRI dan bukan hanya itu NYAII. insya
allah saya akan coba untuk membuka usaha sendiri demi mencukupi
kebutuhan keluarga saya sehari-hari itu semua berkat bantuan NYAII..
sekali lagi makasih banyak ya NYAI… bagi saudara yang suka main togel
yang ingin merubah nasib seperti saya silahkan hubungi NYAI RONGGENG,,di no (((082-189-481-547)))
insya allah anda bisa seperti saya…menang togel 275
juta, wassalam.

dijamin 100% jebol saya sudah buktikan…sendiri….

Apakah anda termasuk dalam kategori di bawah ini !!!!

1?Dikejar-kejar hutang

2?Selaluh kalah dalam bermain togel

3?Barang berharga anda udah habis terjual Buat judi togel

4?Anda udah kemana-mana tapi tidak menghasilkan solusi yg tepat

5?Udah banyak Dukun togel yang kamu tempati minta angka jitunya
tapi tidak ada satupun yang berhasil..

Solusi yang tepat jangan anda putus asah….NYAI RONGGENG akan membantu
anda semua dengan Angka ritwal/GHOIB:
butuh angka togel 2D 3D 4D SGP / HKG / MALAYSIA / TOTO MAGNUM / dijamin
100% jebol
Apabila ada waktu
silahkan Hub: NYAI RONGGENG DI NO: (((082-189-481-547)))

angka GHOIB: singapur 2D/3D/4D/

angka GHOIB: hongkong 2D/3D/4D/

angka GHOIB; malaysia

angka GHOIB; toto magnum 4D/5D/6D/

angka GHOIB; laos 4D/6D/8D/

Angka GHOIB; thailan 2D/3D/

Angka GHOIB; macau 2D/3D/4D/

Angka GHOIB; sidney 2D/3D/4D/

DEMI ALLAH INI ADALAH KISAH NYATA SAYA
INI ASLI, BUKAN REKAYASAH !!?
This image was also posted here:
The UK NATIONAL LOTTERY scam
The UK NATIONAL LOTTERY scam



Keywords:
You are on page 2 of 2, other pages: 1 [2]

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: