View Single Post
  #6  
Old 01-10-2010, 05:21 AM
prickle
Hill Giant
 
Join Date: Sep 2009
Posts: 147
Default

for database stuff it's fairly straight forward. If you do not have the phpMyAdmin package installed on Mint then you can always use command line.

With command line you'll do something like:
Code:
mysql -u<User Name> -p
<type in password>
after the above you will be greeted with a mysql prompt ( mysql> ). You'll want to log in as the admin user for your MySQL installation (usually 'root' on typical Linux installs) during the above steps.

Next you will want to run the following commands:
Code:
create <database name>;
use <database name>;
source <path to .sql files>;
With the above it's a little bit easier if you 'cd' to the directory with your database files (sql files) first. That way you can just use "source <filename>" to import the SQL file. Repeat for all the other SQL files you need to import.

Optionally, if you have phpMyAdmin installed you can do the following:
.point your web browser to your servers phpMyAdmin (on my box it's http://localhost/phpmyadmin/)
.log in as the MySQL admin/root user
.in the "MySQL localhost" section of the first page after logging in, type in a database name you want to use for this
.click create
.Click the databases tab
.Click the database you just created
.click the Import tab
.Click browse
.locate your sql files
.Select ONE of them
.Click open
.Click Go
.Repeat for however many files you need to import

hope this helps
Reply With Quote