MYSQL :: Error Loading Mod_auth

Error Loading Module Php_mysql.dll >
I have a problem with Apache 2.0.52 and php.ini where I have actually decommented out the module extension = php_mysql.dll and have provided the path c:php5ext where the dll resides.

I have also copied the dll to the windows xp system directory. No matter what path I put or what I do, the error message when restarting apache says that the dll could not be found. I tried enabling some other random dlls, and some work fine, whilst some dont.

Any suggestions as to how I can get around this problem? I also added another extension for php_mysqli (i extension) .dll and the same problem happens when restarting apache: unable to load dynamic library link file - module not found.

Mod_auth_mysql V2.20
I am having two problems with mod_auth_mysql.

1) ENCRYPT("str") only encrypts the first 8 characters on my system (FreeBSD 5.X). I want to allow users to have passwords up to 16 or even 24 chars. If I use MD5 or PASSWORD however, the mod_auth_mysql does not grant access even if the username / pw combination are correct. How can i encrypt my members' passwords and allow them longer PWs while using mod_auth_mysql?

2) If I have a field in my members table such as status that has values like blocked, probation,active, etc,...is there a way I can have mod_auth_mysql 2.20 only grant access if a specific value such as "active" is in the "status" field for a given record? Several years ago I had a version of mod_auth_mysql that allowed me to do this but I lost it.

Libmysqlclient.so.10 Is Needed By (installed) Mod_auth_mysql-1.11-12
Redhat 9.0
Mysql 3.23.56 ==> Running

I want to upgarde to 4.0.13 but this is the error it says:

[root@localhost downloads]# rpm -Uvh MySQL-server-4.0.13-0.i386.rpm
warning: MySQL-server-4.0.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5

error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
libmysqlclient.so.10 is needed by (installed)
perl-DBD-MySQL-2.1021-3
libmysqlclient.so.10 is needed by (installed) php-mysql-4.2.2-17.2

If i install with -i will it install with the backward compatibility, it
should not break those dependencies.

Mod_auth_mysql Or Mysql Usernames And Passwords
I'm writing a web app that needs a login page. I'm doing the dev on a
windows box although the final version will go on a Linux box. I can't
find any versions of mod_auth_Mysql precompiled for windows and have no
idea about compiling c.source on windows (or anything to do it with).

Is there a good reason I shouldn't store hashed password in MySQL and
call them from Python scripts instead of using the apache auth module
directly?

Loading A New DB
I'm trying to populate a new copy of my database from the dump script taken from an overnight backup. It starts out OK but then errors with: ERROR 1060 (42S21) at line nnn: Duplicate column name 'id'.
Taking a look at the script I can see that the previous couple of tables have loaded without problem but the offending CREATE TABLE looks like this:

CREATE TABLE xxx (id int(11) NOT NULL auto_increment, <other columns...> ,PRIMARY KEY (id,id)) ...

The id column is only defined once but is duplicated in the PRIMARY KEY definition - strange! Looking through the script I see this is the case on some of the other CREATE TABLE statements also

Loading Data
in my data file i have ten of these in same format how would i load all in
my database from the text file. what would the mysql command be or should i
add something to separate each actor or what? ......

Loading Blobs
does anyone have a perl example of loading blobs from either a bin file
or an input stream?

Loading Csv Data
If you made a table to collect daily stock price in what order would your data be added to the table? Would it be ascending with the recent date towards the top or would it be descending with the recent date towards the bottom?

Also would it be wish to use the date as a key?

Loading A Database
I try to load a new database like this:

mysql> mysql < databasenamedb_2006-06-29.Thursday.sql

but then I get:
mysql> mysql < databasenamedb_2006-06-29.Thursday.sql
---> ...........

so a prompt. What is that prompt wanting? A username or a password?
What should I enter.

And in order to create a new database like this, should I do something else first? Like adding the database with "create databasenamedb;"?

Databases Are Not Loading
I am using Mysql 4.0.18. I load my database (tele) in "data" directory at c:mysql. The first time, I opened WinMySQLadmin and 3 databases appeared: test,mysql and tele. It was Ok. Then I restarted my computer and I went to WinMySQLadmin again and didn't appear mysql and tele database. What I am doing wrong or what is the problem?

Loading Data
how to load data into the tables

Load_file() Not Loading
I'm trying to load a picture into an image database. On my old server it worked fine and on this new one it returns null all the time. Let's say I try:

UPDATE tbl_1 SET blob_col=LOAD_FILE("/tmp/picture.jpg") WHERE id=1;

I get a null even though I should have permissions, the file exists, and the max_allowed_packet is set high enough. The file is on the server and I'm typing into the MySQL command line but nothing. All other UPDATE statements work fine. Just the load_file doesn't work. What am I doing wrong?

Loading Schema
I've been importing a database from a MSSQL server - not massive, 146 tables, about innodb_buffer_size 20GB total data and everything is fine with running queries - performance is good considering it's on a dev box at the moment.

Problem I have though is when you are using phpmyadmin or the mysql administrator it takes an age to load table data (in mysql admin it says 'Fetching schema table status').

These are innodb tables (I'm concerned myisam won't cope with us - lots of small updates and big slow queries) and if I convert the tables to myisam the problem goes away - loads fast as you like.

Is this a problem inherent to innodb or is there a configuration to get around it?

I'm running with default my.ini atm with the exception of innodb_buffer_pool_size=500M.

Loading A Database
I am running MySQL 3.23.46 on my laptop (Win XP), and wondered how I go about loading a database schema?Can this be done from the command prompt for instance, or is it easier to do so using PHP? I have PHP 4 loaded.

Loading Data
To log onto mysql client server I entered
mysql -h linuxproj -u myusername -p --local-infile=1

I was able to get into mysql with no problem after entering my password. Then to load the data from a .txt file stored on my computer I entered

LOAD DATA LOCAL INFILE 'C:/Program Files......../file.txt INTO TABLE Tablename FIELDS TERMINATED BY ',' LINES TERMINATED BY '
';

I got the error 'C:/Program Files....../file.txt'- Error 2 is not found. I dont know why.

Loading Many Files
Say i have a database that has 3 varchar fields and then a blob field. I can easily fill the first 3 fields with a tab delimited file. However how can i load multiple files into the blob field. Say i have 700 records- i can't do it by typing out the command over and over again. Is there a way to write a file specifying all the files that need to be loaded and then feed it mysql like i can do with a tab delimited file? Or is there another way?

Loading Data
how should my data format look like to load it to MySQL table?
Where should field name stand and where the records, what are deviders, which format

Loading Rate
I'm working on a project where we need to load several 10s of
thousands of rows per second (roughly 50 bytes/row) into MySQL tables.
We're using LOAD DATA INFILE, which works fine. The problem is, that
we have to write this data from our application into ASCII files so
load data infile can read them. The bottleneck is the writing of the
data. We were thinking that if we could write the data in binary
format, the writing might be quicker. Is there a way to load binary
data into mysql tables with something akin to load data infile?

Loading Text
a tab delimited file like this:

name is varchar (60)
bio is TEXT data type

name<tab>bio
Jack<tab>name: My name is Jack
car: I have a chevy car
pet: My pet's named Fido

Jane<tab>name: My name's Jane
car: I have a VW car
pet: I don't have a pet

How do I LOAD that into MYSQL ?I want name field and the a text bio field but how do I get it in a table assuming I have line breaks...I'm willing to globally edit the file if needed

Loading Database From .txt File, Please Help! Thanks
I'm very new to mysql and programming in general, just learning the basics, and currently I'm trying to access a database that was formerly on a different server and compressed into a large .txt file, and I also have a version of it in .tar . So the database is on my computer, and I'm just trying to view it through mysql on my machine, windows xp. I have tried the following:
c:> "program filesmysqlinmysql.exe" -u root -ppassword < file.txt
system unable to find the file
I currently have the file in the 'database' folder I created in the mysql directory. should it be somewhere else? should I change its type through properties?
If you have any suggestions for me could you please let me know.

Loading Binary Data
I have a large data set of binary data files and I'd like to create a database so that I can search on the data contained in these files. I'm new to database development but from what I've seen it is only possible to store & search variables in the database in text format. Is it possible to load the files as binary variables and still use MYSQL commands to search and manipulate the database?

For example, assume a file contains a variable X which is a 32-bit floating point number ranging between 0 and 10. Does the variable X have to be converted to text first (possibly using a C program), stored into another text file, which is then loaded into the database/table? Or is it possible to load the 32-bit floating point number directly from the original binary file and perform a MYSQL query looking for instances of variable X with values 1.2 and 4.8?

Loading Mysql Table
I'm trying to make a simple photog gallery, using phpmyadmin....but I need to load the table with all the image filenames. i.e.: pic001.jpg, pic002.jpg, pic003.jpg, ....... I don't want to sit there entering every single filename (if I dont have to). My question is, is there any way I can write an SQL script, to automatically load, let's say .... pic001.jpg - pic300.jpg into the mySQL database?

Loading Pictures In Mysql
I know you're going to say search the mail archives, but I have and I can't
find an answer to my simple question of is there an SQL statement to load an
image in a .jpg file into a database table?

Also, I have read in lots of places that it's probably not a good idea to
store images in mysql but just store a pointer to the file. Is this the
accepted way of doing things with mysql?

Loading Data Into A Table
I have to load some data into a table (several tables actually). I obviously don't want to/can't insert the records one-by-one. I'm running mySQL versoin 4.0.13. Apparently I can't use the 'LOAD DATA LOCAL INFILE' with this version. Surely there should be another way of doing it?

Loading Mysql On A Windows - IIS
I have a personal web server (IIS) that i am trying to install mysql with...or install mysql so that it is available through my IIS server.

I d/l it...now what? is there a GUI for mysql that i can use? a gui like access or something. if i create databases in mysql at home, how do i get them on a ISP server...

Loading A MySQL Backup
I have a problem loading a MySQL backup from one system into another system. On system A I give the following command:

mysqldump -pxxxxxx Joomla > joomla_backup.sql

On system B I have created a database Joomla and I give the following command: Code:

Set Commit When Loading Data?
I am useing MySQL 4.1 for unix. I am loading a large data file to a singular table useing this command: mysql> load data local infile 'test.txt' into table testagain;

I get an error of running out of memory when loading. So I would like to set an automatic commit to take place after it gets to 100 to 10000 records (does not matter) to avoid running out of memory. How do I do this?

Loading Text Files
Im currently having problems loading a tab seprated file into mysql database.

It loads the data but with each field only loads half the data i.e. txt file contains "hello how are you world" (for a field) SQL table contains "hello how"
Not sure whats causing this as i've opened the same file in excel and it works perfectly (renamed it from .txt to .xls)

Fail Loading Data
I have a file creted using notepad where fields are separated by tabs. I try to load it using LOAD DATA LOCAL INFILE '/../name.txt' INTO TABLE mytabke

I get the following message:

Data truncated for column 'column name' ay row 1 error 1265

and this is repeated for al columns in the windows file.

Bulk Loading Data
I want to insert massive amounts of data in near real-time into a MySQL database. The data is in a structured binary format, and I have code that parses the data into logical data structures.

Right now I can load into a MySQL database via ODBC, but I need to improve throughput. How can I bulk insert the data more efficiently?

I would prefer not to use LOAD FILE because it involves converting the binary format to text, which will have a much larger footprint. To illustrate the pain of text files in my application, a single binary file might contain up to a million rows! And I might load hundreds, if not thousands of these files in a day!

How can I load data directly into the database at a lower more direct level than LOAD FILE? What are my options to integrate my data parser with MySQL?

Loading Mysql Extension For Use With Php-cgi.exe
I used this php package to install on my system...

PHP 5.0.0 installer [2,235Kb] - 26 July 2004
(CGI only, packaged as Windows installer to install and configure PHP, and
automatically configure IIS, PWS and Xitami, with manual configuration for
other servers. N.B. no external extensions included

It

Loading Excel Files
Is there any way to load excel files into mysql tables as we do fro text files?

Loading A Text File
To insert information into my tables ive been trying to create a .txt with all the information in. bit when i try to load it by entering
mysql> LOAD DATA LOCAL INFILE '/path/"name".txt' INTO TABLE "name"; it comes up with
ERROR 2 (HY000): File 'path"name".txt' not found (Errcode: 2)
ive been saving my .txt file onto the desktop.

Loading Database Script
I am very new at this, but understand a bit about webdesign. I am trying to duplicate an online database created by somebody else (I have their permission). They sent all the programming files to me, and we had a database created on the server. I also have SQL script for creating the tables, etc. But, I am unsure of what to do with the script. I tried to load it via the MYSQL command prompt, but ran into trouble when trying to follow the steps on the Dos command prompt. It said Access denied for my username and password.

I am on the right track? How do I successfully load this script, and then how do I link my dreamweaver programming files?

Loading Excel Into MySQL
I know that I can load my excel file using

LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '
';

my CSV has the following data:
school_code,etscode,namelong,
street,city,zip,email,phone

but the table is set up like so:
"school_code","schloccd","schtypcd","schtmpcd","namelong",
"namespec","abbr","city","state","hsaa","termtype","loccode",
"etscode","phone","url","email","region","street","zip","gen_info",
"crs_num_sys","repeat_policy","grading_scale","comments",
"new_fl","update_init","update_dt","create_init","create_dt"

basically, the table i want to import into doesn't follow the same order. What do you suggest?

Loading A File Into A TABLE
I am new to MySQL. I am trying to load from a text file to a table,
and am having problems
with the fields in the text file being translated to the correct fields
in the TABLE. Right now,
I have a tab between each field in the text file, something like:

Chicago USA 2,500,000
New York USA 5,000,000
Madrid Spain 2,000,000

My question: Can I use something else to differentiate between fields,
like a coma?

Slow Loading Times
It takes more than 30 seconds to load the phpmyadmin page. On a localhost server.
It says
Fatal error: Maximum execution time of 30 seconds exceeded in c:appservwwwphpmyadminlibrariesmysql_wrappers.lib.php on line 101

This sometimes also happens when loading my local website that uses MySQL.
I've tried reinstalling, but it doesnt help.

PhpBB Slow Loading
my site runs quickly except when a user hits forum (allready signed in or logging in) to login to the forums it takes 10x as long to get to the forums as it does the rest of the site, once in the forums its ok and runs as normal,is there any settings in SQL that can speed this up? or is there another problem.

Loading From A Text File
I am using Xampp tool for a project which has to do with processing of lot of data. The problem is that hundreed thousands of data is generated every day in text file (comma separated or pipe separated doesnt matter) and all I want to do is to insert all these values in the appropriate tables. I looked for this feature in mysql GUI tools byt I couldnt find anything.
Another thing; Could be text file be imported automatically in any time we desire?

Loading Fixed-Width
I need to load fixed-delimited (positional fields) text files into mySQL tables, but don't know how to accomplish this. Sample text file data is as follows (data is properly aligned, but in sample below it gets messed up with this editor):

aaaaa bbb 11111 4444
jkjxjk hjh 22222 3333
eeeee bbb 33333 8989
yuyuy ccc 22222 9999

I'm loading this data on mySQL in Windows and don't want to have to go through intermediate steps to get it loaded vi tab or comma-delimited fields since it will require a complete conversion of the files.
Also, how do you selectevely load some fields and skip others with the load utility?

Reduce Data Loading Time
At present i am working with a database that contains all countries and their cities. My database is in mysql. The city table contains 3079703 cities.

When a user selects a country i need to populate the city dropdown for that country. I use Ajax technology to retrieve city from database based on the selected country.

But I am facing a problem with the speed as it takes a long time to retrieve city data and return generated dropdown control from server using php.

I have already tried to use filebased caching (transferring all the city data into separate files for each state and country) and then tried to load from these files but didn't gain any significant speed improvement. I also then tried using indexing in city table on country code and state code but it still takes time to load.

Could someone please give me any techniques or optimisation tips so that i can load the cities within a short time.

Need Your Help: Techniques For Loading A 800 MB+ File Into MySQL
I've been attacking this problem from several angles but I haven't found a solution that works all that well.

I have a textfile, approximately 800 MB in size, that contains character strings separated by newlines. For example:

WHATEVER
SOMETHINGELSE
OHYEAH
WHOOSH

I have tried using mysqlimport and I also wrote a script to wrap INSERT statements around each character string, after which I piped the resulting SQL file into MySQL. However, both drug on for more than 12 hours and ended up crashing the server (thankfully it's my own personal "test lab" server).

I'm not really sure what I can do here. Short of writing a script to parse the text file into several chunks to be inserted using mysqlimport incrementally, I really don't know what can be done that won't end up taking forever or crash the MySQL server (and underlying OS).

Data Loading With Foreign Key Contraint
a question regarding adding a record into a database that has foreign key constraints. Remember, I'm a total newbie so I'm hoping I'm using the right words to express this. I'm taking a class that required us to use an ER diagramming tool. This tool generates SQL table create scripts in mySQL. After a little tweaking I got the scripts to work. An example is as follows:

# Create Table : 'Jobdesc' Job Description for Requisition
# desccode :
# jobdescription :
# levelcode : (references JobCode.levelcode)
# jobcode1 : (references JobCode.jobcode)
# jobcode :
# titlecode : (references JobCode.titlecode)
#
CREATE TABLE Jobdesc (
desccode CHAR(8) NOT NULL UNIQUE,
jobdescription MEDIUMTEXT NOT NULL,
levelcode CHAR(2) NOT NULL,
jobcode1 CHAR(8) NOT NULL,
jobcode CHAR(8) NOT NULL,
titlecode CHAR(7) NOT NULL,
PRIMARY KEY (desccode,jobcode),
INDEX idx_fk_Jobdesc (titlecode,jobcode1,levelcode),
CONSTRAINT fk_Jobdesc FOREIGN KEY (titlecode,jobcode1,levelcode)
REFERENCES JobCode (titlecode,jobcode,levelcode)
ON DELETE CASCADE
ON UPDATE CASCADE) TYPE=INNODB;

This is a create script for a job description table. Job descriptions are related to a jobcode table. That table in turn is related to joblevel and jobtitle tables (i.e., the job title and job level determine the job code). The jobcode is needed for each job description.

One problem I have is that the create scripts generated from the ER tool makes all fields in the job description entity NOT NULL. If I try to just enter the description code (desccode), the job description (jobdescription) and the associated job code (jobcode) I get the following error:

#1216 - Cannot add or update a child row: a foreign key constraint fails

This happens if I just try to enter the desccode, the jobdescription, and jobcode datta. I think this is happening because jobcode1, levelcode, and titlecode are NOT NULL so when I update the record it attempts to enter data (NULL) into these fields which are child row. Can someone explain what I should do? Should I just change these fields of data into NULL?

Loading Text Fields Into Tables
Let's say a tab delimited file like this:

name is varchar (60)
bio is TEXT data type

name<tab>bio
Jack<tab>name: My name is Jack
car: I have a chevy car
pet: My pet's
named Fido

Jane<tab>name: My name's Jane
car: I have a VW car
pet: I don't have a
pet

.....

How do I LOAD that into MYSQL ? I want name field and the a text bio field but how do I get it in a table assuming I have line breaks...I'm willing to globally edit the
file if needed....

Loading A Database Table With Data From PHP
I tried making a php file that updates my database when it's executed from a browser... But the table doesn't get loaded properly with the data. I can't get it to work. Here's my code:

Loading Date Strings As Dates
Now that MySQL 5.0.15 is production ready, are there any functions to
use with mysqlimport, so I can load a string such as, MM/dd/yy, in a
text file into a MySQL database as a yyyy-MM-dd date value.

Segmentation Fault When Loading Mysql
I am configuring mysql, apache and php in linux operation system. i
have configured the apache and php but while configureing the mysql
or trying to execute mysql from konsole a "SEGEMENTATION FALULT" is
shown instead showing the mysql screen.

Loading DB Objects On Command Line
I am creating scripts so that they can load SQL objects, tables, procedures, triggers etc. automatically into the database.

Here is the question:

when I use 'mysql' command line utility, specifying username, password AND database, do I still have to put 'use dbname' inside the sctipt _OR_ can I assume that the objects will be loaded into the database specified in the command line ?

Error Loading Mod_auth_mysql