Converting from MS SQL Server to MySQL

I am sure conversion questions are asked a lot, I need to move what is a MS SQL Server database to a MySQL database, both table stuctures, data, and a web application with a very large number of queries. I am looking for any advice on this undertaking, things to be mindful of and such, and if

RE: Converting from MS SQL Server to MySQL

The *best* way to do this is via conversion software. I find that for table creation and data transfer, http://dbtools.com.br has the best free tool. It converts all your Access and SQL based databases over to MySQL without any hitches. Really good help files and web site as well. Intelligent

ERROR 1064?

Hi, I am comparable new to mySQL, so sorry if I might bother you with a newby Problem: When I connect to the database via phpMyAdmin or via the mySQL Command Line Tool as root I have problems creating a view (root has all privelegs, and the pure select statement works fine in the line before):

Re: Converting from MS SQL Server to MySQL

Hi, I am sure conversion questions are asked a lot, I need to move what is a MS SQL Server database to a MySQL database, both table stuctures, data, and a web application with a very large number of queries. I am looking for any advice on this undertaking, things to be mindful of and such,

4.0.18 repeatedly restarts

Hello, After upgrating mysql 4.0.7 to 4.0.18/FreeBSD 4.6.2, the mysqld restarts each time it receives a remote connect from another client machine. Here is what is written into the log: 040415 08:51:00 mysqld started 040415 8:51:00 Warning: setrlimit returned ok, but didn't change limits. Max

Re: ERROR 1064?

Klaus Neudecker [EMAIL PROTECTED] wrote: Hi, I am comparable new to mySQL, so sorry if I might bother you with a newby Problem: When I connect to the database via phpMyAdmin or via the mySQL Command Line Tool as root I have problems creating a view (root has all privelegs, and the pure

Re: mysqld_multi

Date: Wed, 14 Apr 2004 13:26:10 -0400 To: [EMAIL PROTECTED] From: Pingouin Team [EMAIL PROTECTED] Subject: mysqld_multi Message-Id: [EMAIL PROTECTED] Hi, I need help. I have my old mysql server running in my web server and I can't stop it for make the test of the new version (3.28 to 4.0). I have

Changeing a columns type with alter

Hello list, Could anyone help me on how I go about if I would like to change a coulmns type from say INT to FLOAT? Should I use the ALTER command? I cant seem to find any info on it in the manual. Regards /Jonas

Re: Changeing a columns type with alter

Doh! dont bother I found it in the manual ALTER TABLE t1 CHANGE c1 c1 BLOB; /Jonas - Original Message - From: Jonas Lindén [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 15, 2004 9:46 AM Subject: Changeing a columns type with alter Hello list, Could anyone help me on

MySql 4.1.1 slow login

Hi all, I have win2k server machine, if this machine online, i could login to MySQL 4.1.1 on RH 9 is about 1 second, but if this machine offline connection establish in about 10 seconds, then i try connect to mysql 4.0.17 in SuSe machine its done in about 1 second. I connect to mysql server

Re: MySQL Timeout Question

Paul Maine [EMAIL PROTECTED] wrote: I am running MySQL version 4.0.18 on a Windows 2000 server system. If I log in locally as an administrator and issues a command such as DESCRIBE TABLE some_table; - everything works fine. If I come back at a later time and run the same command again - it

Re: permissions of ordinary users?

beginner [EMAIL PROTECTED] wrote: Hi, i got mysql 4.0.13 on my machine. When i installed it, i did only basic stuff to get it running (bascilly hit setup). Now, i'm getting a little bit closer to mysql (the system starts to became more friendly), but i got the following problem: - if i

Re: foreign keys help

saiph [EMAIL PROTECTED] wrote: i'm studing foreign keys but my sql code does not react as would imagine when i insert inconsistent data. i.e. create database urls; use urls; create table caths ( name varchar(7) primary key ) type = innodb; create table urls ( name

international LIKE in 4.1.1-alpha

Hi! Win2000, MySql 4.1.1-alpha, cp1251 select '' like '%%'- 1 select ' ' like '%%'- 0 It's a pity 8( Hint : select ' ' like '%%%'- 1(change leading % to %%) Variables: character_set_system=utf8 character_set_server=cp1251 character_set_database=cp1251

Installing MySQL-3.23.54-1 pkg on RaQ4i

Hi All, I am trying to install MySQL-3.23.54-1 pkg on a RaQ4i (from pgkmaster.com), which is something I have done on numerous occasions without problem. However, this RaQ for some reason does not have /tmp/mysql.sock installed when the package is installed. When I uninstall the pkg, the script

Re: chroot and run as user on SuSE 9

Duh...never mind. I found the answer buried in my old notes. I'm building a dynamic binary since I'm using SSL. In case anyone else has the same issue, you need a lib/libnss_compat.so.whatever in your chroot environment. Works like a charm. Steve At 09:58 PM 4/14/2004, Steve Slater wrote: Has

Re: international LIKE in 4.1.1-alpha

Juri Shimon [EMAIL PROTECTED] wrote: Hi! Win2000, MySql 4.1.1-alpha, cp1251 select 'ÃÎÍ×ÀÐÀ' like '%ÃÎÍ×ÀÐÀ%'- 1 select 'ÎËÅÑß ÃÎÍ×ÀÐÀ' like '%ÃÎÍ×ÀÐÀ%'- 0 It's a pity 8( Hint : select 'ÎËÅÑß ÃÎÍ×ÀÐÀ' like '%%ÃÎÍ×ÀÐÀ%'- 1(change leading % to %%) Variables:

Re: Server not configured as slave

jim [EMAIL PROTECTED] wrote: Does this machine have a valid server-id? Run show variables like 'server_id' from the mysql monitor. Interesting. The my.cnf says server-id = 75 but the show_variables; command says server_id 0 (zero). Why would that be, and could it be the problem?

export to csv or excel

Hi, Do you know a good tool to export mysql tables to csv or excel files? It should be able to run on a Linux system, and should be able to be scheduled (cron job). I worked with EMS Mysql Export on a Windows system, this worked fine, but I can't get it to work on the Linux system. I also tried

Query 2 DBs

Hi, 2 DBs sitting on different machines, any idea of how to run the query? Select a.*, b.field1 from computernam.db1.table1 a, computername.db2.table1 b where a.fieldx = b.fieldx where computername is host for DB. regards

Re: Complicated Inner Joins

Here's another rotter! I searched UseNet and read that in MySQL you cannot have a sub-select, but I'm lost as to how to split this into two selects? SELECT distinct p.ProjectID ,p.ProjectName FROM tbl_project AS p INNER JOIN ( ( (tbl_UnitType AS ut INNER JOIN tbl_RateType AS r ON

Re: Query 2 DBs

Hi, 2 DBs sitting on different machines, any idea of how to run the query? Select a.*, b.field1 from computernam.db1.table1 a, computername.db2.table1 b where a.fieldx = b.fieldx where computername is host for DB. As far as I know, you cannot. With regards, Martijn Tonies Database

Re: international LIKE in 4.1.1-alpha

Juri Shimon [EMAIL PROTECTED] wrote: I was able to repeat it on 4.1.1 but your example worked fine on 4.1.2. Where I can get it? Binaries currently are not available, but you can install it from development source tree: http://dev.mysql.com/doc/mysql/en/Installing_source_tree.html

please ignore

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 please ignore - -- ~ |...| ~ | _ _|Victor Medina M | ~ |\ \ \| | _ \ / \ |Linux - Java - MySQL | ~ | \ \ \ _| | |_) / _ \ |Dpto.

RE: export to csv or excel

Use phpmyadmin. Damn good for data dump in any format you wish... -Original Message- From: Bart De Man [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 6:59 AM To: [EMAIL PROTECTED] Subject: export to csv or excel Hi, Do you know a good tool to export mysql tables to csv or

ignore

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, i been having problems with my mail server, just ignore this message. - -- ~ |...| ~ | _ _|Victor Medina M | ~ |\ \ \| | _ \ / \ |Linux - Java -

RE: export to csv or excel

I use a PERL module called Spreadsheet::WriteExcel. You can get it from CPAN at http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/. I generate tons of reports monthly using cron to fire off PERL scripts that output my data as Excel spreadsheets using this module. Implementation is

Re: Installing MySQL-3.23.54-1 pkg on RaQ4i

mysql.sock only exists while the server is running. Your package install/uninstall scripts are broken. Phil Ewington - 43 Plc wrote: Hi All, I am trying to install MySQL-3.23.54-1 pkg on a RaQ4i (from pgkmaster.com), which is something I have done on numerous occasions without problem. However,

RE: mysql error file

So I am guessing this is not a bug, and that I will have to modify the script myself? -Original Message- From: Luc Foisy Sent: Monday, April 12, 2004 4:34 PM To: Michael Stassen; MYSQL-List (E-mail) Subject: RE: mysql error file Michael wrote: mm... Have you looked in

RE: MySQL Cluster

You can also use pae for any one process to address 4 GB of ram on a 32 bit system. -- DVP -Original Message- From: Tim Cutts [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 2:05 PM To: Adam Erickson Cc: [EMAIL PROTECTED] Subject: Re: MySQL Cluster On 14 Apr 2004, at

Reminder: uc2004.vbmysql.com

Hello Everyone; I thought I would take a chance to remind you all of the blog collection and image gallery available at http://uc2004.vbmysql.com We have had over 30 blog entries posted since the conference started, written by several bloggers and encourage more to contribute. If you were not

InnoDB

MySQL Experts: I am new for MySQL database. We have a 4.0.18 MySQL sit on Linux box. I am reading on InnoDB. And having a question. How do I know the table is configured by InnoDB instead of normal table ? Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB is

RE: InnoDB

Hi Jenny, mysql SHOW VARIABLES LIKE '%have%'; ++---+ | Variable_name | Value | ++---+ | have_bdb | YES | | have_crypt | NO| | have_innodb| YES | | have_isam | YES | | have_raid | NO| |

RE: InnoDB

How do I know the table is configured by InnoDB instead of normal table ? Do a show table status or a show create table name_of_my_table Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB is configured? No, but if you don't want to use innodb you can add skip-innodb in

Re: MySQL Cluster

On Wed, 14 Apr 2004, Tim Cutts wrote: On 14 Apr 2004, at 10:57 pm, Adam Erickson wrote: (This is probably not the best place for this post, but here goes...) The (soon to be released) MySQL cluster software docs use a sample cluster node configured with Dual Xeons and 16GB of ram.

Re: Strange Index Usage: select ... where foo = 90 on a varchar

On Apr 13, 2004, at 2:01pm, Michael Stassen wrote: You shouldn't be surprised. This is normal behavior. interchangeStatus is a varchar, so select fileName from outDocInterchange where interchangeStatus = 91; requires that interchangeStatus be converted to an int for each row so it can be

Re: Strange Index Usage: select ... where foo = 90 on a varchar

On Thu, 15 Apr 2004, Max Campos wrote: On Apr 13, 2004, at 2:01pm, Michael Stassen wrote: You shouldn't be surprised. This is normal behavior. interchangeStatus is a varchar, so select fileName from outDocInterchange where interchangeStatus = 91; requires that interchangeStatus

MySQL 5.0.0-alpha-max-debug running on localhost as ODBC@localhost

This appears when I attempt to open phpMyAdmin. It doesn't matter what account I set in the config.inc.php file, I continue to get this error. How do I change this so that another account logs in to the localhost? I unfortunately had to reboot my server and this became the result. I notice that I

Fatal error 1236 (replication)

Our master suffered a power failure. When fixed we brought up its only slave and found that it wouldn't replicate. The error log revealed that the slave was requesting replication from an impossible position: Slave SQL thread initialized, starting replication in log 'dbm-bin.041' at position

AW: please ignore

That's a lot of stuff to ignore but I managed to do so successfully -Ursprüngliche Nachricht- Von: Victor Medina [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 15. April 2004 13:39 An: [EMAIL PROTECTED] Mysql. Com Betreff: please ignore -BEGIN PGP SIGNED MESSAGE- Hash:

MySQL Cluster

MySQL just announced their MySQL Cluster product. But the minimum requirements for it include a Xeon/Itanium/Opteron CPU and a SCSI drive with a RAID1 controller. Why is that? Seems strange. http://www.mysql.com/products/cluster/faq.html -- MySQL General Mailing List For list archives:

Slow Connection from PHP to MySQL 5.0

Hi Folks. I've seen similar questions asked both here, and via a google search - but I haven't found an answer which has helped yet - so heres hoping!! I run a Linux webserver which has PHP 4 installed, and am currently prototyping a design using MySQL 5.0-alpha on Windows 2K professional. The

MySQL cluster

Hi All, Is there some version of MySQL cluster available for downloading at the moment? If yes, where is it? Thanks in advance. Cheers, Wensheng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT ?

Hi, Is it possible to select all records from one table that don't have an entry in another table. Something like: SELECT t1.* FROM 'TABLE1' AS t1, 'TABLE2' AS t2 WHERE t1.cv = 1 AND t1.id != t2.id So in this mock example there is an id in one table, but the id is not in another

Re: MySQL cluster

On Thu, Apr 15, 2004 at 03:05:01PM -0400, Wensheng Deng wrote: Is there some version of MySQL cluster available for downloading at the moment? If yes, where is it? Thanks in advance. MySQL Cluster is currently only available in source form as part of the MySQL 4.1 BitKeeper repository (which

Re: SELECT ?

Absolutely, do a left join and check for NULL values from the other table. SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL The left join retains all records in the first table regardless of matches in the second. You then filter out those records with a null value in a

RE: SELECT ?

Hi, Thanks. So what you are saying is if a record is not there it is considered NULL? Regards, Justin Palmer -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 12:54 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: SELECT ?

InnoDB corruption

Hi, Im using Win98 with mysql 4.0.1-alpha-max-debug. My main database has only InnoDB tables and, I dont know how, some tables were corrupted. My problem is using the CHECK statement I can find where the corruptions are but I cant repair them with REPAIR (error message: table

Error ?

Hi, I get this error from a query: #1066 - Not unique table/alias: 't2' What does it mean? Can anyone point me to a place where I can look up what these codes actually mean? Any help would be great. Regards, Justin Palmer -- MySQL General Mailing List For list archives:

FW: Error ?

The query that generated this error was: SELECT t1. * FROM `wat_student_profile` AS t1, `wat_student_job` AS t2 LEFT JOIN t2 ON t1.student_id = t2.student_id WHERE t1.cv != '' AND t1.sevis_id = '' AND t2.student_id = NULL LIMIT 0 , 30 Regards, Justin Palmer -Original Message- From:

RE: Error ?

Hi, Can anyone give me a hint to what this error message is trying to say. Thanks, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:38 PM To: [EMAIL PROTECTED] Subject: FW: Error ? The query that generated this error

RE: Error ?

Your join syntax is incorrect. Check out: http://dev.mysql.com/doc/mysql/en/JOIN.html In particular, you join against an alias (t2), when you need to join on an actual table. On Thu, 2004-04-15 at 14:25, Justin Palmer wrote: Hi, Can anyone give me a hint to what this error message is

RE: Error ?

Sounds to me like it doesn't the the alias name T2 but might need the full table name. Hi, Can anyone give me a hint to what this error message is trying to say. Thanks, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15,

command not found: trying to start mysql

binary 4.1 on Linux. to start mysql, i have to be in: /usr/local/mysql and execute: ./bin/mysql -u root mysql If i'm in another directory, I get command not found: trying to start mysql. Seems to me this is a PATH issue. I had binary 4.0 working here at one time, but I'm delete most if

Learning curve

Hi all! I'm wondering if anyone can help me find out how much time/training is needed to accomplish my task using MySQL. My background: I'm fresh to the world of MySQL and databases in general. I do have some fundamental knowledge in the area of programming and databases, but nothing too

Indexing a TEXT column

Using mysql 3.23.53, i have a table with approx 1.000.000 records, and only 3 columns. One of these (called 'value') is usually between 50 and 150 characters, but occasionally jumps to a current maximum of 570 characters, so I figured I had to go for the TEXT type. now I tried to add an index

Re: Learning curve

Mike T. Caskey wrote: Hi all! I'm wondering if anyone can help me find out how much time/training is needed to accomplish my task using MySQL. My background: I'm fresh to the world of MySQL and databases in general. I do have some fundamental knowledge in the area of programming and

Re: Learning curve

Mike - You didn't indicate your department, so I'm not sure what your background is. Your message, overall, is a bit scary, as any university that far behind right now would be worrisome. I'm not exactly sure what you're asking for (as you didn't ouline your requirements), but I would first

Proces table entries

Hi, When trying to improve system performance of my webserver, I found out that there are 10 entries of [mysqld] in the Unix proces table (ps aux), even when there are only one or two processes visible with the mysqladmin proceslist command. Those entries in the Unix proces table consume much

AW: command not found: trying to start mysql

Try ls to see whether safe_mysqld is in the directory and the run: Safe_mysqld Note! You have to be root to run the mysqld demon HTH Babs -Ursprüngliche Nachricht- Von: Don Dachner [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 15. April 2004 21:48 An: [EMAIL PROTECTED] Betreff:

Multi-User Issues

Hi Joshua, I would love to here more about multi-user issues (like record locking). I searched the archives by the title and by your name with no luck. If you don't feel like going into detail, could you point out some good links to learn more about the subject. Regards, Justin Palmer

Locking tables

I've found a nice shell script to use to backup my server's MySQL databases. https://sourceforge.net/projects/automysqlbackup/ However, when I tried this earlier today it resulted in a corrupt table. Now the table in question is one I've had issues with for other reasons, but it has over 2 mil

Re: Proces table entries

At 23:51 +0200 4/15/04, Rob Schuurman wrote: Hi, When trying to improve system performance of my webserver, I found out that there are 10 entries of [mysqld] in the Unix proces table (ps aux), even when there are only one or two processes visible with the mysqladmin proceslist command. Those

Query Question

Hi, I am wondering if this is possible: Say I have a table with 2 columns, Column_Count and Column_TotalCount; Is it possible to use a query to select all rows from the table where Column_Count is greater than Column_TotalCount? Like this: SELECT * FROM mytable WHERE Column_Count

Re: Query Question

Hello, Friday, April 16, 2004, 12:50:21 AM, you wrote: M Is it possible to use a query to select all rows from the table M where Column_Count is greater than Column_TotalCount? M Like this: M SELECT * FROM mytable WHERE Column_Count Column_TotalCount; Perhaps you ought to try it before

Re: Multi-User Issues

Just to get a general feel for interest: Should I just whip up something quick and dirty and post to the mailing list, or should I work up a nice page or two and put it on a web site? Anyone else interested? Warnring: to work up something, it might be a week or two as school is getting really

Re: Query Question

I did try it, and it doesn't work, I was looking for Ideas that will work. Hello, Friday, April 16, 2004, 12:50:21 AM, you wrote: M Is it possible to use a query to select all rows from the table M where Column_Count is greater than Column_TotalCount? M Like this: M SELECT * FROM

how to rewrite this query without using temporary table

Hi, I have 2 tables.patientrecall_table and appointment_table.The patientrecall_table used to store what is the nextrecall date for the patient while the appointment_tablewill store all the appointments made.Now, I'd like to get through this:"Patients Due for Recall, but No Scheduled

Re[2]: Query Question

Hello, Friday, April 16, 2004, 12:56:32 AM, you wrote: M I did try it, and it doesn't work, I was looking for Ideas that will work. Obviously not, because that's exactly how you do it. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List

Re: Query Question

At 16:56 -0700 4/15/04, MYSQL wrote: I did try it, and it doesn't work, I was looking for Ideas that will work. Looks to me like it should work. Try this and see what you get: SELECT Column_Count, Column_TotalCount, Column_Count ColumnTotalCount FROM mytable; That'll show you what's in the

Query Question

It should work if both columns are numerical. Say int, decimal, float, double and so on. Babs -Ursprüngliche Nachricht- Von: MYSQL [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. April 2004 01:50 An: mysql Betreff: Query Question Hi, I am wondering if this is possible: Say I have a

Can not get an answer here - how to force the index block size to be the same?

It seems to be either a hard question or stupid question:). Is there anyway in Version 4.1.1 I can force all the indexes to have same block size? Say 2048? If it is plain impossible without changing the source code, please let me know. I really appreciate any help on this. Thanks HT

Re: Can not get an answer here - how to force the index block size to be the same?

I don't know the answer to your question but I'm curious to know why you would want to do this. Normally, that sort of detail is handled by the database and should not be a consideration for any user of the database. In other words, your queries should work regardless of whether the block sizes

Re: Can not get an answer here - how to force the index block size to be the same?

At 17:34 -0700 4/15/04, Haitao Jiang wrote: It seems to be either a hard question or stupid question:). Is there anyway in Version 4.1.1 I can force all the indexes to have same block size? Say 2048? If it is plain impossible without changing the source code, please let me know. Why do you care

Re: Server not configured as slave

jim [EMAIL PROTECTED] wrote: Does this machine have a valid server-id? Run show variables like 'server_id' from the mysql monitor. Interesting. The my.cnf says server-id = 75 but the show_variables; command says server_id 0 (zero). Why would that be, and could it be the

repeated/duplicated query problem

Hello fellow listoers, Long time reader first time poster. :P I just recently installed a MySQL server to back-end a mail system (PHP webmail, SMTP, and IMAP servers). Everything is working pretty well, but I have a reallt odd problem I can't difure out. I've asked a few times in #Mysql on

how to rewrite this query without using temporary table

Lorenzo, Try this: select P.ssn from patientrecall_table as P left join appointment_table as A on P.ssn = A.ssn and appdate between '2004-04-15' and '2004-04-30' where P.nrd = current_date and A.ssn is null Before applying the where clause, the left join will have - a row for

Re: Can not get an answer here - how to force the index block size to be the same?

Paul Because I want to use the load index into cache... to pre-load the indexes into cache. But I can not use this feature since the block size of indexes are different (1024 vs. 2048), and the load index into cache.. complains about it. Any idea? Thanks a lot! Haitao --- Paul DuBois [EMAIL

Re: Can not get an answer here - how to force the index block size to be the same?

Because if you want to pre-load indexes into cache, you need to have same block size for all indexes of a table. --- Rhino [EMAIL PROTECTED] wrote: I don't know the answer to your question but I'm curious to know why you would want to do this. Normally, that sort of detail is handled by

help! recover from running mysql_fix_privilege_tables on mysql4.0

While trying to fix some problems with the user access privileges on mysql4.0 alpha, I run the mysql_fix_privilege_tables script. http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html As the result, I can't get to the database, even using the root login. I tried to recover root

Slightly OT: MySQL + PHP and escaping data to output to a web page

Hi all. Yes I know this is a little off-topic, but also a little on-topic... I have a user who likes to use the 'less than' sign ( ) in notes he enters into the DB. When I print them out to a web page, they are interpreted as an HTML code and everything after them '' is not printed. I'm

PHP + MySQL Not Playing Nice Any More

So I'm using PHP and MySQL to serve up a game and all is going well until today. The first problem came when for some reason the game was sending apache as the username to access the db (which is not what I have in the dbconnect file) and output some errors. I checked the page it was complaining

Re: Locking tables

Did I really ask that tough a question? Anyone? On 4/15/04 7:38 PM, Mark Susol | Ultimate Creative Media [EMAIL PROTECTED] wrote: I've found a nice shell script to use to backup my server's MySQL databases. https://sourceforge.net/projects/automysqlbackup/ However, when I tried this

Re: PHP + MySQL Not Playing Nice Any More

On 4/15/04 11:46 PM, Joseph A. Nagy, Jr. [EMAIL PROTECTED] wrote: So I'm using PHP and MySQL to serve up a game and all is going well until today. The first problem came when for some reason the game was sending apache as the username to access the db (which is not what I have in the

Re: Slightly OT: MySQL + PHP and escaping data to output to a web page

On 4/15/04 11:49 PM, Daniel Kasak [EMAIL PROTECTED] wrote: I'm currently using: replace(replace(NoteText, '', '#060'), '', '#062') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this? You can try the php command:

Re: Slightly OT: MySQL + PHP and escaping data to output to a web page

Mark Susol | Ultimate Creative Media wrote: On 4/15/04 11:49 PM, Daniel Kasak [EMAIL PROTECTED] wrote: I'm currently using: replace(replace(NoteText, '', '#060'), '', '#062') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this?