>> Site Map >> Forums >> Blocks
Forum module - topics in forum:
Blocks - Having problems with a block? Code doesn't work, get help here.
sql files
where are they located at? I have looked my server over and can find no where to put the sql files with blocks that have them. I'm sure this sounds like a stupid question, I looked in db folder and seen none, is that where the add on block sql's go?
ah found out how to do it, through php my admin, sorry, delete this thread
| Quote: : |
| have looked my server over and can find no where to put the sql files with blocks that have them. I'm sure this sounds like a stupid question, I looked in db folder and seen none, is that where the add on block sql's go? |
Actually it's not stupid question. In fact it's one of the more intelligent questions anyone has asked me in all the years I have been working on websites.
*.sql files do not get uploaded to your server. In fact they don't go on your server at all. You query a sql file.
To do this you simply open your contorl panel (cpanel) and add the contents of the *.sql file you your database. This is done by opening phpMyAdmin and selecting your database. Once you have opened phpMyAdmin you and selected your database. You will see at the top of the screen 5 tabs one will be called SQL, click it. Once the SQL screen opens, click browse and do just that browse to the location of your *.sql file and then click open, after that just click go and the new tables will be automatically added to the database.
You can also copy and paste the contents of a *.sql file to the window called "Run SQL query/queries on database" and then click go.
Either way you do it make sure you back up your entire database before proceeding.
phpMyAdmin can also be used for many other functions like optimizing your database for better performance (structure) and backing it up(export).
