Importing database from phpMyAdmin
Thursday, November 15th, 2007One of the first steps during the installation of LinkBidScript is creating a database and populating it with initial data.
Database creation is pretty much self explanatory and can be done with few simple clicks from practically any hosting admin panel. The step many users seems to have problem with is importing SQL file.
Here are step-by-step instructions how to get it done.
From your hosting admin panel (in many cases it will be cPanel) go to MySQL management (sometimes it may say Database management).
Click on phpMyAdmin link for the desired database. Some hosts using individual phpMyAdmin interface for every database and some have only one for all databases.
In the left column you will have list of the databases available for management from this interfase. Right below the database name (still in the left column) will be list of existing tables (none for new database) in the selected database.
Click on the name of the database you want to work with.
In the right column on top of the page you will see number of tabs: Structure, SQL, Search, Query, Export, Import, Operations.
In some versions of phpMyAdmin tab “Import” may be missing…
If you version of phpMyAdmin has “Import” tab - click on it, if you don’t have it try to click on “SQL” button.
What we are looking for is text “Location of the text file:” with the text field box and “Browse” button next to it.
Click “Browse” button, select lbs.sql file from your local disk where you extracted LinkBidScript archive and click “open”. Now location of lbs.sql file will be shown in the text box. Click “go” button somewhere below.
If everything worked as expected you’ll get the message: “Your SQL query has been executed successfully” and detailed list of performed operations. Also you will see list of new created tables below the database name in the left column.
That’s it. Your new LinkBidScript database is ready to use.
