RE: [Mysql-discussions] Migration from windows to linux red hat
mysqldump is for dumping the file. you can load it with specifing FILE yourfilehere Read the manuals for more information, Also, try to search on the website www.mysql.com a little more before asking things here. I got the feeling that when you feel a itch, you ask what it is, that is not bad, but i would love to see some pre-search things from you like: I Searched on the website but found nothing with this query, then i tried x, but that also did not work, so i thought i ask it to the ML. Please try it :) Thanks, -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene mrtg.grunn.org Dutch mirror of MRTG -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: dinsdag 10 februari 2004 20:24 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] Migration from windows to linux red hat Hi, I have 10 tables which I want to migrate from windows mysql(V4.0.17) to red hat mysql(V3.23.54).How to do that pl? Some tables are having real data also. thx -seena - Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [Mysql-discussions] HOW TO RUN SQL and default value ?
mysql -ppassword -u username -e shell commands for sql like select that can be runned from any shell script. use enum to check Y/N TRUE/FALSE etc. CREATE TABLE testtest ( test ENUM( 'TRUE', 'FALSE' ) NOT NULL ); it automaticly sets true as default value with me. otherwise add: DEFAULT 'FALSE' after not null Hope this helps -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene mrtg.grunn.org Dutch mirror of MRTG -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: maandag 9 februari 2004 22:14 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] HOW TO RUN SQL and default value ? Hi, How to run script at mysql prompt? Like if i want to create a table or select some query and I want to put those sql statement into one file ,how to run that and what would be the extention of that query? I want to create on column which contains only default value TRUE or False.how to do that? Create table test1 (no int, flag char (6) default ... thx -seena - Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: HOW TO RUN SQL
if you want to do sql scripting then i suggest you use a bash script with the settings i provided to you oh If you are able to, please don't use HTML mail thanks cheers -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene mrtg.grunn.org Dutch mirror of MRTG -Oorspronkelijk bericht- Van: Seena Blace [mailto:[EMAIL PROTECTED] Verzonden: maandag 9 februari 2004 23:11 Aan: Remko Lodder; [EMAIL PROTECTED] Onderwerp: HOW TO RUN SQL how to run sql script like if i have mysql prompt mysql at above prompt I want to run sql script. how to do this? what will be extenstion of file? Remko Lodder [EMAIL PROTECTED] wrote: mysql -p -u -e that can be runned from any shell script. use enum to check Y/N TRUE/FALSE etc. CREATE TABLE testtest ( test ENUM( 'TRUE', 'FALSE' ) NOT NULL ); it automaticly sets true as default value with me. otherwise add: DEFAULT 'FALSE' after not null Hope this helps -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene mrtg.grunn.org Dutch mirror of MRTG -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: maandag 9 februari 2004 22:14 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] HOW TO RUN SQL and def ault value ? Hi, How to run script at mysql prompt? Like if i want to create a table or select some query and I want to put those sql statement into one file ,how to run that and what would be the extention of that query? I want to create on column which contains only default value TRUE or False.how to do that? Create table test1 (no int, flag char (6) default ... thx -seena - Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [Mysql-discussions] Help! Too many connections error
probably you had over 100 connections to you SQL db, on tcp level. the default max is 100 connections, perhaps you can increase it a little --max-connections=200 for example (in your startup config) hope it helps you. cheers -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Mark Verzonden: zondag 8 februari 2004 19:12 Aan: MySQL List Onderwerp: [Mysql-discussions] Help! Too many connections error I started getting an error: #1049: Too many connections Around 10 hours ago, and I don't know what it means. My admin is sort of a go between with the host provider, so I need to give him as much information as possible to get the problem fixed. I haven't made any changes to the site, although I was testing some optimized SQL statements using LEFT JOIN with phpMyAdmin prior to the error occurring. Thanks for any help you might provide. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ___ Mysql-discussions mailing list [EMAIL PROTECTED] http://lists.elvandar.org/mailman/listinfo/mysql-discussions -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [Mysql-discussions] Newbie call for HELP!
did you notice that you are using MSSQL instead of MySQL. You are appearing to miss drivers or something however, perl has some possibilities to connect to MSSQL hosts, checkout www.cpan.org for that. Cheers -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Chadley Wilson Verzonden: vrijdag 30 januari 2004 13:28 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] Newbie call for HELP! Hello I need to know how to get data base connectivity to a windows SQL2000 server from linux based app. Are there any tools that I need. When I try to connect I get this error DBMS MSS Microsoft SQL Server 6.x is not supported in your current installation I am sure that it is just client connectivity but the question is How in linux. -- Chadley Wilson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ___ Mysql-discussions mailing list [EMAIL PROTECTED] http://lists.elvandar.org/mailman/listinfo/mysql-discussions -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [Mysql-discussions] SQL CONNECTIVITY
your php is not configured to use mysql? perhaps? and just what is linux9? please install php with mysql support. -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 17:12 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] SQL CONNECTIVITY Hi all, I have been noticing following error message with PHP. Fatal error: Call to undefined function: mysql_connect() Let me know how to fix that.I have installed linux9,apache 2.0, php. thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [Mysql-discussions] SQL CONNECTIVITY
That would be good, But installing php does not mean that mysql features are also added. Please checkout your php configuration if it is included, otherwise install the appropiate packages from redhat -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 17:44 Aan: [EMAIL PROTECTED] Onderwerp: RE: [Mysql-discussions] SQL CONNECTIVITY I installed php. what is linux9? =RED HAT 9 aCTUALLY i WANT TO develop smal webbased application.I was thinking PHP,MYSQL,APACHE AND LINUX WOULD BE good,but any other combination would be great if you guyes suggest. Remko Lodder [EMAIL PROTECTED] wrote: your php is not configured to use mysql? perhaps? and just what is linux9? please install php with mysql support. -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 17:12 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] SQL CONNECTIVITY Hi all, I have been noticing following error message with PHP. Fatal error: Call to undefined function: mysql_connect() Let me know how to fix that.I have installed linux9,apache 2.0, php. thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [Mysql-discussions] SQL CONNECTIVITY
you need to install this file, findable on the ftp servers from redhat php-mysql-4.2.2-17.i386.rpm ftp pwd 257 /pub/redhat/linux/9/en/os/i386/RedHat/RPMS (ftp.redhat.com/pub/redhat/linux/9/en/os/i386/RedHat/RPMS/) how that further works i dont know since i dont use redhat at all. goodluck -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 18:52 Aan: [EMAIL PROTECTED] Onderwerp: RE: [Mysql-discussions] SQL CONNECTIVITY Remko, is any parameters value do you want me change in php.ini file? which package do you want to install from redhat pl? Remko Lodder [EMAIL PROTECTED] wrote: That would be good, But installing php does not mean that mysql features are also added. Please checkout your php configuration if it is included, otherwise install the appropiate packages from redhat -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 17:44 Aan: [EMAIL PROTECTED] Onderwerp: RE: [Mysql-discussions] SQL CONNECTIVITY I installed php. what is linux9? =RED HAT 9 aCTUALLY i WANT TO develop smal webbased application.I was thinking PHP,MYSQL,APACHE AND LINUX WOULD BE good,but any other combination would be great if you guyes suggest. Remko Lodder wrote: your php is not configured to use mysql? perhaps? and just what is linux9? please install php with mysql support. -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 17:12 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] SQL CONNECTIVITY Hi all, I have been noticing following error message with PHP. Fatal error: Call to undefined function: mysql_connect() Let me know how to fix that.I have installed linux9,apache 2.0, php. thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [Mysql-discussions] netstat
Hi adam, you can tell mysql to listen on 127.0.0.1, the loopback interface, --bind-address=IP , add that to the startup parameters of MySQL if you require access from othermachines to your db but want to restrict every other host, you can , or you should use a firewall.. iptables is a good firewall for that purpose, cheers -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Adam Hardy Verzonden: zondag 25 januari 2004 14:19 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] netstat I'm running a web server with Apache Tomcat and mySQL for the first time and I've been following various recommendations to make the server more secure (it's Linux Debian). One of these recommendations is to keep the number of open ports to a minimum. I'm looking at netstat (see the output below) and it makes me wonder if the mysql port needs to be open at all, since the tomcat and mysql database are running on the same machine. Can I block off these ports? Would I have to use a firewall to do that? (like ip_tables) Thanks Adam Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 localhost:8005 *:* LISTEN 30723/java tcp0 0 *:mysql *:* LISTEN 1890/mysqld tcp0 0 *:www *:* LISTEN 30723/java tcp0 0 *:ssh *:* LISTEN 248/sshd tcp0 0 *:12121 *:* LISTEN 267/perl tcp0 0 *:smtp *:* LISTEN 239/master tcp0 0 *:https *:* LISTEN 30723/java tcp0 0 localhost:mysql localhost:1311 ESTABLISHED 1890/mysqld tcp1 0 localhost:1312 localhost:mysql CLOSE_WAIT 30723/java tcp0 0 localhost:1311 localhost:mysql ESTABLISHED 30723/java -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ___ Mysql-discussions mailing list [EMAIL PROTECTED] http://lists.elvandar.org/mailman/listinfo/mysql-discussions -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [Mysql-discussions] Websphere and mysql
if you can normally connect with plain settings to the mysql server, then it might be the drivers from websphere, which then tell me, ask them :) in addition you can dump traffic from the websphere thingy to your db server in order to see WHAT the packages are carry-ing so that you can see for yourself what is being sent, what should be sent, and does it actually sent anything at all? Hope this helps -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Juan Alvarado Verzonden: zondag 25 januari 2004 16:49 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] Websphere and mysql Hello: I have been trying to configure websphere 5 to use mysql. I have set up the datasource using the mysql driver and whenever I test the connection from the websphere admin console, I get the following: Test Connection failed for datasource Securance Datasource on server server1 at node linux with the following exception: java.lang.Exception: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: com.mysql.jdbc.Driver. View JVM logs for further details. null If this was the wrong list to post, please forgive me and let me know which is the appropriate list to post. Thanks in advance - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]