MySQL Database Forum

Hi, I have a 80 meg dump file created with mysqldump. I need to import it into a mysql db on Windows. On linux, I say "shell>mysql dbname < dumpfilename" But that does not work on Windows. Importing via phpmyadmin is not possible either since we are limited to 2 Meg file size. Any ideas? Please help.

Hi everyone... I know this isn't strictly a php/mysql ng, but I was hoping maybe someone here knows both languages and is willing to help. I have a directory of text files that i'd like to import into a msql table... I was wondering if there's an easier way to do this with php/mysql, I'd like to avoid copy/pasting the entire directory...

I have 2 dbs a)Relation User | Group 4 | 2 4 | 3 5 | 4 5 | 5 4 | 4

I have a MySql database I connect through using mysql-connector-...jar under java. I need to co-exist with another MySql database in order to get this one job wherein the fields of the other database can map to fields in my database. For example, they have a customers table as does mine. There may be some differences in the fields and such,...

Hi I need to select 2 tables . The field 'p_description' is not always aviable but i still need to print it to the screen SELECT * FROM task,p_description WHERE ComponentIDLink = 34 OR task.TaskID = p_description.pTaskLink GROUP BY TaskID ORDER BY TaskName

I was getting started with Jumpline, and everything looked great, but then I started having problems with my web application. Turns out it was designed with MySQL 4.x, and Jumpline is running 3.23.58. Customer no-service says it's my tough luck, and they won't be upgrading anytime soon. So I only have a few days to find a new host. I need...

HELP ! ! ! I hope someone here can tell me how can i declare a Vendor-Specific attribute in MySQL Control center. In the regular radius i declare it well. I check the radtest and its write : radclient:WARNING: Malformed RADIUS packet from host 10.0.1.16: Vendor specific attributes do not exactly fill Vendor-Specific

Hi all, I'm currently managing a site with information from our members such as phonenumbers and emailaddresses, stored in a table. I would like to retrieve the emailaddresses from the table and create a distribution list from it. Right now I store the addresses twice, first in the mysql-table, and second in mailman. I would like to...

Is it somebody out there who has made a migration from an Oracle server to an MySQL server?? The scenario is as simply: I've got a Oracle 8 server with a database with content that I want to transfer to a MySQL database. No special data, constraints etc that MySQL not will handle. My solution is to reverse engineer the database from...

Hello! I am in the process of designing a large scale MySQL database. I expect anywhere from 10 to 100 thousand entries in the main user table. While that is not very many in terms of MysQL, I am still concerned about overhead that I may be building into my application. The main user table is necessarily large (in terms of numbers of...

I accept that fulltext index would be bloated due to all the atomic indexing it has to do. BUT, looking at my mysql db directory, for each table, there is a single index file consisting of all the indecis - regular and fulltext put together. The result is that to access any simple index, the whole monsterous index file has to be pulled...

Does anyone knows how to copy database from one server to another. By copying I mean literally everything, not just the database. I know we can dump the database from one server then reload it to another one. However, I have a specific need for this and here is my problem: I have my development server as of RedHat 9.0 and I install the...

Hi, I want to set up a mysql server in an embedded process. I managed to start the server in my program as described through mysql_server_init() Now I need a client connection to this server. mysql_real_connect

I have to handle a very big (~50 gigabyte) database (quite all in a table), and I am going to use mysql. Can mysql handle all that ammount of data? What problems I am going to have? Should I take any precaution? Is some other database-engine more suitable for this work? Posgresql maybe?

Hello, I am in the process of creating a website which uses PHP/mySQL. I have root access to this server. What I need to do is to put a script in place (via cron?) which will select all records from my database which are within a certain time frame (basic sql date math), and use the result to put an email together which be sent...

Hi, I'm trying to do a MySQL Query using Mysql 3.23.58 something like that below SELECT name FROM customers WHERE name LIKE "Fred" ORDER BY difference(name,"Fred"); The difference piece doesn't seem to be working (Syntax Error returned). Is this not possible without upgrading the server? or am I doing something wrong, all I want to do...

I am *NOT* using local at all, just so you know. My webhosting server's stats: MySQL: 4.0.20-standard phpMyAdmin: 2.5.6 Apache: 1.3.31 (Unix) I open phpMyAdmin, choose my 'links' database and the 'external' table that is currently empty but has its fields created. Then I click the 'SQL' tab and then the 'Insert data from a...

I am trying to using mysql as back-end for an application(web) running on the window 2X, one thing I am not sure is that once I establish the connection between database server and application, should I keep this connection open while application is running, or only open it when there is a requet to qury records from database? Thanks for...

When I run the query (please see below) between 08:30:00 and 17:29:59, I get the data from row 1; if I run the same query between 17:30:00 and 08:29:59, I get the "empty set." Can anyone explain why? Many thanks! Table SQL:

Hopefully someone can help me here. I have a personnel database with numerous tables, although only a few are required for this particular query. I will name them as follows: master - holds personal details about an employee,with the "staffno" field as primary key; psnexams - details number and type of exams a person has passed. Linked...

Dear friend, I am Mrs.kate koroma wife to the late john koroma from Sierra Leon. I am writing you in absolute confidence prmarily to seek your assistance to transfer our cash of($12,000.000.00) now in the custody of a private Security trust firm in Europe. the money is in trunk boxesdeposited and declared as Precious stones by my late...

When I setup MySQL database (running scripts/mysql_setup_db) inititally the program create 3 big files: + ibdata1 (data file) 10 MB + ib_logfile0 (first log file) 5 MB + ib_logfile1 (second log file) 5 MB I want to setup this as 5,0,0 with autoextend. Does anyone know how to ? I try to google but...

Ok, I took a whack at this, but it's still not returning anything. Granted I used Dreamweaver to create the queries, but I must be messed up somewhere. Any help would be appreciated. 1st Query: (this ones works wonderfully) mysql_select_db($database_db********, $db********); $query_new_review_one = "SELECT Artists.Artist,

I'm on a hosted Linux server and I have an Outer Join query that's returning on one less row than I expect. There are two rows very similar and I expect them both returned. There are similar other cases of rows all being returned. I've googled: debug mysql query I've searched on mysql.com for 'debug' Alot comes up but all relates to...

Hello, I have two tables "contact_tbl" and "address_tbl". I have a query that compares the email addresses between the two. If a match is found I need to update a specific field in "contact_tbl" with a value of 'yes'. My query is: SELECT * FROM contact_tbl INNER JOIN address_tbl ON contact_tbl.email = address_tbl.email;