Re: [PHP-DB] Query Case In-sensitive
Generally in DBs, data is case sensitive. Simply you can do an uppercase or lowercase conversion in both sides. Ex : Select item number from item where upper(item_code) = upper(m1234); -ramki - Original Message - From: Larry Sandwick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 1:23 AM Subject: [PHP-DB] Query Case In-sensitive Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data being stored is m1234 Query Select item number from item where item_code = M1234 ; The query above should return the data above. TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Is it possible to access MySQL table on server A from server B?
even if the domain name expired, most likely you will be able to access the site database using the ip address. but just that you have to give / have permissions to connect from the new domain or ip. Also, if you can login to the server with ftp, i guess you can ssh / telnet to server and take a mysql_dump (backup). You can write a ftp code in php. get all the source code in the old server and write it in the new server. -ramki - Original Message - From: Trisha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 12:23 PM Subject: [PHP-DB] Is it possible to access MySQL table on server A from server B? Someone let me use their extra web space so I would have a banner-free place to put my site. After their domain name expired, they didn't re-register it, and didn't let me know ahead of time. I wasn't thinking properly, so I had not created a backup of any of the tables in my database. I have purchased my own domain now, and am wondering if there is any kind of code I can execute from my current domain to copy or back up the tables from the old domain. I believe the database has not yet been deleted, since my user account has not been deleted, and all of the files I've uploaded through FTP are still intact. I've sent several e-mails to the company that was providing the shared hosting package, but did not receive any response, so I don't think they will help in any way. If anyone could me know if accessing the database on the old server from the new server is possible and how to do it, or if I'm just plain old SOL, I would greatly appreciate it. Thanks in advance :) Trisha __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to get data from excell file?
Hi To my knowledge, there isnt any function. you could try setting a dsn for xl file and use it through odbc in php. -ramki Spychaa Wojciech wrote: I want to get data from excell file. Is there in php some function making it possible? For example something like functions reading from dbf's. Thanks Wojtek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Database backup
mysqldump -A /path_to_file/filename.sql for eg: mysqldump -A /tmp/alldatabases.sql This generates a sql file which can be used as backup or for restore... Hope it helps.. -ramki Chris Payne wrote: Hi there everyone, Is there a quick way I can backup all my databases on Linux so I can download them to my HD/Burn them onto CD? I've started a very large travel project and there is going to be over 100 DB's in the end, each with who knows how many tables and going through PHPMyADMIN and exporting 1 DB at a time is going to take forever. My Server is the Rehat Linux 8.0 with Apache and MySQL and PHP. Thanks, any help would be really appreciated (And save me alot of headaches). Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php