Re: [LUG] Uploading MySQL

[Peter Walker <peter.walker@xxxxxxxxxxxxxxx>]

Richard Brown wrote:

> Hi
>
> I have rewritten the emails and put them into two. Here is the first 
> problem I have. I have compiled a sql database on my home computer and 
> now want to load it up to the server. I was told to write a sql query 
> to upload the database. 

Hi Richard,

I see you are trying to follow the instructions on the UKLINUX site 
(uklinux.net/support/mysql.php3). As Neil said it is important to check 
that your SQL file works OK on a local database and it looks like you 
have a shell file mixed up with it as Mike said.
If it does work locally then I would try the following.

Make sure you have access to the UKLINUX database by logging in to 
phpmyadmin (freewebhost.uklinux.net/phpmyadmin 
<http://freewebhost.uklinux.net/phpmyadmin>). You should see your 
database in the dropdown menu in the left frame. If it is not already 
selected select it.

At this point we know your database exists and you have access to it.

If your SQL file is small then you can use phpmyadmin to load the new 
database.
Click on the database name in the left frame to get the home page for 
the db.
Click on the SQL tab there.
Browse to the location of your SQL file (button at bottom of frame) and 
hit the go button.
Your SQL file should be uploaded to the server and executed. Tables 
should appear in phpmyadmin.

If your SQL file is large then you will need to follow the procedure 
outlined by UKLINUX.
Upload your customised script file to mysqlimport.cgi in your webspace. 
Make sure it is executable.
Upload your SQL file to the same directory with the name used in the script.
Browse to the script.

Cheers,

Pete


--
The Mailing List for the Devon & Cornwall LUG
Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the
message body to unsubscribe.