Running an SQL on my database

[DaveSlats]

Dear All,

 

Just a (probably very) basic query.

 

I am trying to install the InfoBox Admin contribution, which asks me to run an SQL file on my database.

 

What is the syntax of the instruction to the MySQL command line interface?

 

Many thanks in advance,

 

Dave Slater,

 

Dublin,

Ireland

[allaboutwicker]

Hi,

 

The way I run my sql files is to use a program which is called phpMyAdmin. You probably have this somewhere in your cpanel (control panel) for your website. On one of mine I have to first go into MySQLAdministration then the phpMyAdmin is in there. Search in your cpanel and you might find it. It was already available in both of the sites I have with different companies. Anyway, hopefully its there, if not maybe you can download it.

 

Assuming its there, what you do is make sure you have made a backup of your database! Just in case. Then go into phpmyadmin and make sure you are in the correct database if you have more then one on your site. You will see several tabs on the top of a box and one will be Import or if that isn't there then click on the one that shows SQL. You should get a Browse button feature. Just browse for where the SQL file is on your computer for the contribution installation and click GO or possibly RUN and that is all! it should do what the file commanded it to do. You may also manually cut and paste the SQL file into the box, but I would prefer to browse for it.

 

Hope this helps!

[DaveSlats]

Thanks for that, I'll give that a go.

 

 

Dave S.

 

Hi,

 

The way I run my sql files is to use a program which is called phpMyAdmin. You probably have this somewhere in your cpanel (control panel) for your website. On one of mine I have to first go into MySQLAdministration then the phpMyAdmin is in there. Search in your cpanel and you might find it. It was already available in both of the sites I have with different companies. Anyway, hopefully its there, if not maybe you can download it.

 

Assuming its there, what you do is make sure you have made a backup of your database! Just in case. Then go into phpmyadmin and make sure you are in the correct database if you have more then one on your site. You will see several tabs on the top of a box and one will be Import or if that isn't there then click on the one that shows SQL. You should get a Browse button feature. Just browse for where the SQL file is on your computer for the contribution installation and click GO or possibly RUN and that is all! it should do what the file commanded it to do. You may also manually cut and paste the SQL file into the box, but I would prefer to browse for it.

 

Hope this helps!