MySQL Database Forum

Greetings. I was running PHP Nuke on a Win2k box using Apache2Triad. Fortunately I backed up the drive using windows backup prior to the hard drive failure. Now I have installed Apache2Triad on another machine and wish to reimport the mySQL database that PHP Nuke relies upon. If anyone can tell me how to do this I would be very...

For some reason I cannot get my MySQL server to start. It has been running fine until Friday, when we has a strange issue with the Solaris server which it is running on. The server had a few files get their chmod setting messed up and now after fixing that, MySQL won't start. Exerpt from neuro18.err: 040830 15:55:19 mysqld started...

Hi, All! I've got a very large table (149 fields -- I know, I didn't create it, and I'm working on changing it...) and I need to add an index to speed up a join query. However, when I run the "create index `index_name` on table(`column`)", MySQL uses every available connection to attempt the creation of the index, and does not allow the...

I am using the GROUP_CONCAT() as follows: SELECT (SELECT CONCAT(ProjectName) FROM Project WHERE FIND_IN_SET(ProjectID, RelatedProjectID))AS RelatedProject We have a project tracker system and we can have one project be related to several different projects. the issue is when there is only 1 related project associated with another...

If I have a merge table that is made up of a set of tables and I want to change the structure of the underlying tables, how do I do it? Will I be allowed to change each table one at a time even though the structure must remain the same among all tables? Also, if primary keys cannot be enforced, does that mean when I do an insert I must name...

When using the load utility on a CSV file, it seems I always need to edit the input file and add an extra comma after the last field in order for MySql to parse the line properly. I use a command like: LOAD DATA INFILE 'absolute path to file.csv' IGNORE INTO TABLE table-name FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES...

OS XP Pro SP2 MYSQL Ver: 5.0.0-alpha nt Whenever I view a table or run a query in the Control Center (0.9.4-beta) I get the following error: ERROR 1146: Table 'shipnet.1' doesn't exist table shipnet.1 indeed does not exist but I can't understand why it's looking for it. Any ideas?

We have been asigned a project required by our parent company to have our sales people fill out a form before billing any order to our customers. Our main system runs a Progress db, that's where our billing, contract and order information resides. For this, we thought that it would be easy on the sales people to design a web form fill out...

I have a mysql db and running on RH linux , how can I export the data from the mysql db on the shell ? thx.

I have a fairly large database on my (2 million records) WIN32 mySQL 4.0.20 The question is: I am adding large amounts of data to it (300,000 to 500,000 at a time) with the standard (INSERT INTO) command. Question is, do I have to reindex, and when and how often? Does mySQL automatically build indexes on the fly as I add data?

Hi all, I ran the myisamchk tool with the options --sort-index --sort-records=1 against an MYI file. Is there something I can use to confirm what this command did? I would like to see what the sort order on the disk for each table in my database. I am using MySQL 4.0.20a-nt running on a Windows 2000 box. Thanks in advance

How can I find the size of data in KB in a blob field? Thanks in advance

Hi all, I used PHP installer binary to install PHP. Then I installed MySQL. Now how do I reconfigure PHP to connect to MySQL? In PHP installer, it does not provide any options for mysql support. Is it possible to do it with PHP binary installer or do I need to reinstall PHP from source code? Hope someone can help me! Thanx

I have 2 tables related by an id 1) id bigint(20) unsigned url text 2) site bigint(20) unsigned word text

I have a table with 5 fields, of which several sometimes have duplicates. example; | id | item | day | hour | ip_address | | 1 | 3 | 2 | 11 | 204.156.33.78 | | 2 | 7 | 2 | 15 | 122.165.177.211 | | 3 | 1 | 3 | 1 | 205.52.79.122 | | 4 | 7 | 3 | 9 | 122.165.177.211 |

Comment faire fonctionner MySQL avec Microsoft Access 2002 ? Existe-t-il une procédure de connexion ? D'avance merci de votre aide

Im trying to write a like query select * from table1 where column1 like 'abc%' (I realize this syntax isnt correct) I want to include any chars from 0-9 in that spot... Does anyone know how to do this? -Craig cstadler18@hotmail.com

Hi, how can i backup a table / entire DB and get the index's as well as the data / create table's etc cheers Greg

I'm using mySQL 4.0.20, interfacing it with phpMyAdmin 2.5.6. I usually set tables up with a "default" type, which I believe is myISAM (or whatever that one is.) But I decided to go with InnoDB for the stability and accuracy. Noticed something on tables in that format I've never noticed in the other format: tbl_product 1 InnoDB - ...

Hi all, I've got MySQL 4.1.3 installed on RH 7.3... everything's fine so far except for getting the init_connect string to work. I followed the instructions on http://dev.mysql.com/doc/mysql/en/Server_system_variables.html and added the below line to my '/etc/my.cnf' file under : init_connect='SET AUTOCOMMIT=0'

Sorry if this has been gone over before, but I checked google groups and I couldn't find anything. Does anyone here have any idea when 4.1.x will be released into production (i.e. come out of beta). It is currently impossible to find a commercial web host who supports it because it is in beta, even though it has been out for a long time...

Hello All, Hope some Guru will be able to help me with this. Let's take this example table A ------------------------------------------------------------------------------- id | TicketNo | evaluation | Username ------------------------------------------------------------------------------- 1 1 ...

I try to install the ARCserve mysql client agent to the RH8 server , when the installation process , it ask the instance ID , what is the ID ? how do I know the ID ? thx.

Hello, Greetings!... How would you like to learn the SECRETS of the most powerful "TRUE POWERLINE BUILDING SYSTEM!" that would generate a substantial monthly income in a short period of time.

I am finding delete queries on large InnoDB tables very slow - are there ways to speed this up? I have a table with about 100 million rows: I am trying to delete just a few of these rows (the following select takes a couple of seconds): > SELECT count(*) -> FROM UserSnap