How do I import a SQL file with over 3000 lines in it ?

Hi all, I have an sql file that I exported from a database of mine that has over 3000 lines (records) in it. How do I go about importing that information into the database ? Previously I was using the same sql to test it, but it was only a few hundred lines or so and I simply cut-and-pasted the

RE: mySQL and odbc

Using phpmyadmin I have granted all priviledges to the user for the database. Any ideas ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, 12 February 2004 4:12 AM To: Adam Staunton Cc: [EMAIL PROTECTED] Subject: Re: mySQL and odbc Have the grant

mySQL and odbc

Hi all, I am getting the following error. I'm pretty sure that I've set the dsn up ok but I still cannot get the test connection to work properly. [MySQL][ODBC 3.51 Driver] Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) The database name, host, password, username etc should

What field lengths to use

Hi all, I just tried to change a field with a type of LongText to Text and with a width of 10 characters in phpmyadmin. It accepted the change of the field type top "text" but didn't seem to accept the change in field length to "10". To test , I entered 20 characters into a text field in my p

Couple of questions relating to bext practice.

Hi all, I have had a new mysql db set up and I noticed that the creator has basically given all fields attributes of "longtext", except of course the date fields and some numerical fields. The longtext fields show up as "memo" when I try and view the data in a gui tool etc. The database has 20