Listen To Two IPs With Running Multiple Instances
I have 2 NICs on my server with IP address 192.168.0.1 and 192.168.0.2. Is there a way to set up MySQL to listen to both IPs at the same time without running multiple instances of the server?
View Complete Forum Thread with Replies
Related Forum Messages:
Multiple Instances In Another Table
I have 2 tables, and want to compare a field in the first table to multiple in the other I'll try to write it not in pseudo code, to try and explain what I would like to do table1-structure field_need_this | field1 | field2 | ... table2-structure field3 | field4 | field5| ... SELECT field_need_this FROM table1 WHERE field1 NOT EQUAL TO (SELECT field4 FROM table2 WHERE value 'something')*this could for example be 4 values. If field1 isn't the same as any of them I would like the field_need_this
View Replies !
Do I Have Multiple Instances Of Mysql Installed?
I'm running ubuntu 6.06, with a web application called Joomla. Right now our databases appear empty.. while i originally panicked, our web application is running smoothly. I cant figure out why this app would work while it needs mysql. Is it possible this is connecting to another instance of mysql on my server and how would i tell?
View Replies !
Multiple Instances: Moving Database?
I have two mysql instances on the same box. I would like to move one database to the 2nd instance. Does anyone know of an easy way to accomplish this, preferably without going through the dump/import process?
View Replies !
Mysql Starts Multiple Php-instances
i have a little problem with a server, running mysql and php. I don't know which php-version i am working with, but the following is the answer for 'mysql --version' mysql Ver 11.18 Distrib 3.23.52, for suse-linux (i686) I know, that this version is not the newest one, but thats not my business. My problem is that i need to execute a script, which starts mysql with this command: mysql -hlocalhost -uuser -ppass db < $update > $update_log whenever this command is running and the 800k $update file is working on the db (a lot of delete and insert statements) there are several php-instances created. So many that they are slowing-down the server, that he is unusable.
View Replies !
Using Linux Symlinks W/Multiple MySQL Instances
We run multiple instances of MySQL on Linux. Each instance has its own directory structure. Along with other databases, each customer has a 5GB non-updating database that is used only for reference. Currently we have multiple copies of this database, which takes up a lot of disk storage. Since this particular database does not get updated, is it okay to have a single copy of it in a commonly accessible location and give the separate instances of MySQL access to it through symbolic links?
View Replies !
Multiple Instances :: Pointing To The Same Data Files/the Same Database?
I think I know the answer to this question, but is it possible and safe to have multiple instances of MySQL pointing to the same data files/the same database? I'm guessing that because only one instance can lock the files at any time that this won't work, but some confirmation would be good. I checked the MySQL documentation, but didn't see anything.
View Replies !
Linux RHE5 Startup Script For Multiple MySQL Instances
I have 2 instances of mysql 5.0.67 installed on one server. They are under 2 separate linux accounts (mysql & mysqldev). Each is installed in a non-standard location: mysql: /opt/mysql/5.0 mysqldev: /opt2/mysql/5.0 Each uses its own data directory: mysql: /ua01/mysqldata mysqldev: /ua03/mysqldata I have ONE /etc/my.cnf file owned & grouped as mysql. The my.cnf file contains the following (commented lines at beginning and end of the file are omitted): [mysqld_multi] mysqld = /opt/mysql/5.0/bin/mysqld_safe mysqladmin = /opt/mysql/5.0/bin/mysqladmin # Here follows entries for some specific programs # The MySQL server for STAGING [mysqld1] mysqld = /opt/mysql/5.0/bin/mysqld_safe mysqladmin = /opt/mysql/5.0/bin/mysqladmin port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M # TNC specifics basedir=/opt/mysql/5.0 ledir=/opt/mysql/5.0/bin datadir=/ua01/mysqldata log=/opt/mysql/admin/log/cricket.log log-error=/opt/mysql/admin/log/cricket.err pid-file=/opt/mysql/admin/log/cricket.pid log-bin=/dbarchive/mysql/cricket-bin.log....
View Replies !
Running Multiple Update Querries In Query Browser
I am trying to run multiple update statements together from the MySQL Query Browser. For example: update table1 set field1 = "123", field2 = '456' where rowid = 'abc' update table1 set field1 = "321", field2 = '654' where rowid = 'efg' I can run them one at a time, but I cannot run multiple updates at the same time. I have 1100 of them to run, so I don't want run them individually. In M$ SQL I can just put a ; or GO at the end of each line to seperate it from the next. How can I do this in MySQL?
View Replies !
Listen To Modifications
I'm using MySQL databases from version 3.23.15 and up. I would like to monitor changes on some tables. Triggers would do great but they aren't supported in the versions I'm running. How could I monitor changes to specific tables and columns. The same functionality should be ideally working on all versions I'm using.
View Replies !
How Make Mysqld Listen To Only 2 IPs
I have an development/test server on a windows 2000 box running. AFAIK mysql needs 127.0.0.1 to connect to the localhost, if I use it on the db-server's machine. Usually I'd connect via LAN so I need mysqld listen on 2 IPs. 1) 127.0.0.1 2) 192.168.1.42 <-- LAN-IP This box has a second LAN-Interface and a third which connects to ADSL. Those 2 are to be considered realm of evel. I just rather have mysql listening on localhost and one of the LAN-interfaces. Is this possible at all ? There is this parameter for mysqld : bind-address It only works with 1 aeddress. Even when I put 2 such lines in my.cnf it just takes the second value. Do I have to let it listen on 0.0.0.0 and let mysqld sort the access attemts with the grant tables ?
View Replies !
Set MySQL To Listen From Other Computers
I have a problem connecting to MySQL server! The server is working on the other computer than my scrpit(my web page). The IP of MYSQL computer is 10.0.0.2. and port 3306! When i try to connect like this : $link=mysql_connect("10.0.0.2.", "user", "password"); $db ="database_name"; ... I get the folowing massage: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '10.0.0.2' (10061) in D:InetpubwwwROOT....... The ip, username, password and database name are all correct! It is said, that it's possible, that the MySQL is set to work on localhost! If this is the problem, where to configure mySQL, to be able to connect from other computer?
View Replies !
Instances Automatically
I have 2 mysql servers happily running on the same box. The default server being on 3306 and socket mysql.sock. With a second server running on 3307 with socket mysql1.sock. I can start and stop these fine from the command line. However I can not figure out how to get both to run autmotically on machine start up / restart etc. The default mysql server starts up fine due to the mysql.server script. I have looked into mysqld_multi, which again i can use fine from the command line as a tool to get both running. However I can not work out how to integrate this or any other technique into the actual startup process.
View Replies !
Setting All Instances Of A Value To Zero?
I am writing a basic CMS for a project and i need to be able to set every instance of a value to zero in a mysql database. eg. there are 20 entries, each with the value '1' in the 'default' column. I want to change all of their 'default' values to 0 in one query. How can i do this?
View Replies !
Anyway To Run 2 Instances Of MySQL On The Same Machine?
I was wondering if there is anyway I can run 2 instances of MySQL Server on the same machine, the reason is I have one machine and I want to be able to simulate my program which really talks between 2 systems accessing their own MySQL server datas but I dont have 2 machines with me all the time to do this, it would be great If I could somehow manage this.
View Replies !
Counting Instances In An Array
I have no experience of designing, databases or using script or code but I now find I have to work with an existing database. I have a field in a table called outstanding objectives. It contains data such as Y,12,Y,Y,1,3,Y (Its is an array writen as text to the field by Flash) another field in the same row indicates the number of items in this array, in this case the entry would say 7. Id like to know how to count the number of Y's in the array, then express this number as a percentage of the value in the second field e.g. 4/7 and then write the percentage value into a new field.
View Replies !
One Value, Unknown Number Of Instances
Say I want to have a DB that keeps track of how many pints (of prune juice) I drink (okay, bad example) Each pint will have a size and the amount of time it took to drink, but I don't know how many pints I will have in each instance. Would I have a table for Pint that had pint_size and drink_time, and then a table DrinkingSession that had num_of_pints? But then how would I log the time for each pint? Could I write a DrinkingSession table that had pint1, pint2 pint3, etc?
View Replies !
Select Most Common Instances
request a list of the top X most common entries in a particular field and order from most common to least common ? so if the values were: b,d,a,b,c,b,c,d,a,c,e,d,d,b,d it would return d,b,c,a,e..
View Replies !
Copying Tables Between Instances
copy entire databases between two pcs (1 has MySQL 6 the other MySQL 5) just fine using... mysqldump -u username_a -ppassword_a --all-databases | mysql -u username_b -ppassword_b -h host username_a - Should be the username for the server you are backing up password_a - Should be the password for the server you are backing up username_b - Should be the username for the new server password_b - Should be the password for the new server host - Should be the hostname or ip address of the new server However I just want to copy 1 table in 1 database. The help file shows: There are three general ways to invoke mysqldump: shell> mysqldump [options] db_name [tables] shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...] shell> mysqldump [options] --all-databases If you do not name any tables following db_name or if you use the --databases or --all-databases option, entire databases are dumped. I've tried various versions of #1 ( themysqldump [options] db_name [tables]) but can't get it to work. I've also tried the --tables --tables Override the --databases or -B option. mysqldump regards all name arguments following the option as table names. But couldn't get it to work either.
View Replies !
Manage MySQL Instances
I am using the version 4.1.12a Windows XP In one customer I found the same version as mine and the ini file has [mysqld] port=3306 server-id = 1 basedir="C:/MySQL/" datadir="C:/MySQL/Data/" and the service is mysqld-nt the question I want to have the same service (mysqld-nt) But different directory of my data datadir="C:/MyData/Data/" How can I do it in the configuration file??
View Replies !
Update All Instances Of A Field To Default Value
Is there a statement or way in MySQL to update a several fields in a database to the default value? Basically reseting the value with out deleting it. I can go through an manually do that by looking at the number and manually setting it to that but it would be easier to just say: Update table set field=default That didn't work but that's what I'm trying to do. While at it is there any easy way to do it with PHPMYADMIN which is what I manage my DB's with.
View Replies !
Query Does Not Work On Some Server Instances
query: Select * From Students Where C_Name = "XXXXXX" WHen I run this query on 2 of my computers, the result returns no rows. When I run this query on a remote machine hosted by 1and1, with a copy of the same database, the query returns the correct row. The syntax is identical.....
View Replies !
Running Two SUM
SELECT SUM(nlamount WHERE nlaccount='3202' THEN 1 ELSE 0 END) AS receivables, SUM(nlamount WHERE nlaccount='3207' THEN 1 ELSE 0 END) AS receivablesvat FROM nominalledger WHERE nlcompanyid=$companyid AND nldate >= $company_end_year GROUP BY nlcompanyid I want to run this script, I basically want to add up nlamount twice, when nlaccount=3202 and nlaccount =3207 i have got te syntax wrong though in the SUM command, I have tried googling it, but there are only basic tutorials in sql outside the SUM instead of inside the SUM
View Replies !
Running 4.1 And 5.0 On Linux
Question: How can I run 4.1 and 5.0 simultaneously on linux - Suse 9.3 in particular? My goal is to do no harm to my current 4.1 setup. Can the 4.1 and 5.0 rpm's play nice together? Can I use the rcmysql commands for running multiple versions?
View Replies !
Running Two Servers
--=__Part1A441A35.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit I am looking into installing 2 mysql servers on the same windows 2000 PC. From what I have found, it is usually possible to have 2 different versions on the same machine. (Usually one for testing and the other for production). However, I am trying to run 2 production servers, one for personal family info, and the other for business opportunity. Being that I just started using mysql, is it possible then to have the same version installed twice, or how do I accomplish my task?
View Replies !
Running Average
How can I get mysql to do a running average of a given field using dates from another column so that the average for each element is for a given time period rather than from the 5 rows next to the element?
View Replies !
Running Sql Scripts
In the past I have always used phpmyadmin to access my mysql database. I am now doing something on a host that does not have php my admin. Can anyone help me either: 1. setup phpmyadmin -- I downloaded and uploaded to the server but I can't seem to get the config file correct or 2. how can I upload a sql script (creating all my tables) to the database.
View Replies !
Running Total
I came across a question earlier on, where i thought they wanted to order by a count in the query and keep a running total. Which it turned out they didn't.. However, that left me wondering.. Is it possible in MySQL? I'm using MySQL 4.1.22. I have set up a basic test table ( this is just a play, this isn't a serious project, i'm just wondering!) which has the following data / layout on creation: Code: ....
View Replies !
Running A Query
I'm following a guide, and it says to do this stuff in my mysql database. However, whenever I try to run it (with slight alterations to the code to try to get it to work) it always gives me a syntax error. What do I have to type exactly? Hers the code: mysql> CREATE TABLE chat -> chtime DATATIME, -> nick CHAR (10) NOT NULL, -> words CHAR (150);
View Replies !
Problem Running 4.1.1
I've tried several clean installs of 4.1.1, but each time I set a configuration, the configuration wizard tells me the server could not be started with an error code of "0". On a winxp machine using Apache 2.0.54 and PHP 4.3.11, what could be the problem?
View Replies !
Running MySQL
I have installed mysql-3.23.54-win and it all seems to have gone OK .... now i want to run it and setup a database. I dont have an icon on the desktop and there is nothing in Start - Programs ..... start it from DOS prompt via C:> C:mysqlinmysql.exe and i get error 2003 cant connect to MySQL server on localhost <10061>
View Replies !
Running MySQL 5.0
I've just downloaded and installed 5.0 on my Pc/ win 98se. When I run the program MySQL Command Line Client, it appears to run for a second then disappears. I see the program flash open for a second and then it is gone.Complete newb needs some help.
View Replies !
Is There A Way To Calculate Running SUM
I have a table (T1) consisting of 2 columns, Date and Observerd as follows: Date Observed 4/1/07 2 4/2/07 4 4/7/07 3 4/10/07 5 4/12/07 1 4/18/07 7 4/22/07 2 and we want to write a query to create a table or a view with the following data: Date ThreeDaySum 4/1/07 9 <-- (2+4+3) 4/2/07 12 <-- (4+3+5) 4/7/07 9 <-- (3+5+1) 4/10/07 13 <-- (5+1+7) 4/12/07 10 <-- (1+7+2)
View Replies !
Running Balance
I have to calculate running balance in a query, I am trying this: set @fin_record_bal1=0; set @fin_record_bal2=0; select id,fin_record_debit,fin_record_credit,@fin_record_bal1:=fin_record_debit-fin_record_credit,@fin_record_bal2:=@fin_record_bal1+@fin_record_bal2 from fin_records The above doesn't work in record one
View Replies !
Running Balance With Where
I am using the following query: SET @bal1=0,@bal2=0,@bal3=0,@bal4=0,@bal5=0,@bal6=0; SELECT Id, Date, FCode, Descr, Debit, @bal5 := @bal5 + DebT AS RunDeb, Credit, @bal6 := @bal6 + CreT AS RunCre, @bal2 := @bal2 + net AS RunBal, Rec FROM ( select fin_records.id, fin_records.id_production_unit as PUnit, fin_records.id_bank_account as BAcc, date_format(fin_records.fin_record_date,'%d-%m-%y') as Date, fin_accounts.fin_account_code as FCode, fin_records.fin_record_desc AS Descr, fin_records.fin_record_debit AS Debit, @bal3 := fin_records.fin_record_debit AS DebT, fin_records.fin_record_credit AS Credit, @bal4 := fin_records.fin_record_credit AS CreT, @bal1 := fin_records.fin_record_debit - fin_records.fin_record_credit AS Net, fin_records.fin_record_rec AS Rec from fin_records inner join fin_accounts on fin_accounts.id=fin_records.id_fin_account where (fin_records.id_production_unit='$up') and (fin_records.id_bank_account='$ba') and (fin_record_date between makedate(year(curdate()),1) and makedate(year(curdate()),365)) order by fin_records.fin_record_date,fin_records.id ) AS tmp; I should build another column to get RunBal2, that should include only records with Rec = 1.
View Replies !
Running Over 100% CPU All The Time
MySQL is running over 100% CPU all the time. Running as high as 150% at time. I have 8GB RAM. My my.cnf settings is as follow: set-variable = innodb_buffer_pool_size=10M set-variable = innodb_additional_mem_pool_size=500K set-variable = innodb_log_buffer_size=500K set-variable = innodb_thread_concurrency=2 set-variable = interactive_timeout=60 set-variable = max_connections=1000 set-variable = max_user_connections=1000 set-variable = key_buffer=512M set-variable = join_buffer_size=4M set-variable = read_buffer_size=6M set-variable = sort_buffer_size=6M set-variable = table_cache=1240 set-variable = thread_cache_size=64 set-variable = wait_timeout=120 set-variable = connect_timeout=60 set-variable = tmp_table_size=512M [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid set-variable = open_files_limit=8192
View Replies !
MySQL 4.1 Running
I've been running mysql 4.1 for sometime and using phpMyAdmin (v2.6.2) to administer the databases. Using php scripts I can also update/insert etc the databases (maintained on my laptop Mac OS X Tiger). Suddenly, I can't get phpMyAdmin to load in the browser. I've also tried other MySQL GUI tools like CocoaMySQL and Navicat....they won't run either. I downloaded and installed phpMyAdmin 2.6.3-pl1 as well but no improvement. Why would mysql run but the admin apps not work?
View Replies !
Running MySQL From A CD-ROM?
I have used PHP and MySQL for a few years now. Just today I can across an application that had a MySQL database running locally off a CD ROM. I did not know this was posible. When the application runs it starts up the MySQL database without the user even knowing they are running it. It is pretty amazing. So I want to do the same thing. Is there any documentation on how to run MySQL locally. I would like to know how to build the database and create tables under these curcumstances.
View Replies !
Running Script
I'm jumping ship from a dead beat host - but first i'm trying the import on my own machine(osX). Exported all my data from phpMyAdmin 2.5.6. I did it in SQL format - one for the structure and one for the data - to a zip file(also tried with GZip).The file starts with comments and is being interpreted as all commnets - it seems there are no carriage returns - however when i look at it in any text editor or in mySql query browser, it's formatted correctly. I can place a carriage return after a comment line and reopen the query in the query browser and everything looks ok...until the next comment. My only thought is that it must be some kind of encoding issue - but i'm pretty lost when it comes to stuff like that.I've tried from the terminal/command line as well.
View Replies !
#1064 - While Running A Doc Example
I plan to use the function ADDTIME(expr1, expr2) in an SQL request. I looked at the doc and tried the normal syntax, but I have always the following error even if I enter the example from the doc, why ? #1064 - You have an error in your SQL syntax. Even if I enter SELECT ADDTIME("1997-12-31 23:59:59.999999", "1 1:1:1.000002"); I am using MySQL under Windows 2000 using EasyPHP 1.7 (Apache 1.3.27, PHP 4.3.3, MySQL 4.0.15, PhpMyAdmin 2.5.3. )
View Replies !
Running Queries
I am running phpbb forums, and I had run into a problem. They gave me a line of code that Im am supposed to run to fix my problem. Now that creates a problem, because that line of code is wrong sql says?? Heres the code.. ALTER TABLE phpbb2_users ADD COLUMN user_timezone float DEFAULT '0' NOT NULL I think the problem lies within the user_timezone part. I get an error 1064, and also it says that the database table phpbb2_users is not there, which I am looking at
View Replies !
Mysqld Is Not Running
cannot seem to run mysql commands, although queries seem to work well as I can make databases and view tables. Hope that makes sense. I installed mySQL 5 on Windows XP and tried to stick with the default installation options and paths. I lauch mySQL from this: ""C:Program FilesMySQLMySQL Server 5.0inmysqld", enter a password (but not a username so I'm assuming that's root user), get a mysql> prompt. So far so good. The following commands do not seem to work though: mysqladmin version mysqladmin variables Typing these commands then clicking the return key brings up the -> prompt. I've checked the processes and "mysql.exe" and "mysqld-nt.exe" are running. From a c: prompt I tried to install mysqld and was told it is already running. What am I missing here? I'm sure it is something very simple... Ultimately I need to bring in a table from a SQL dump from another system. I've tried using variations of: mysql -h host -u user -p dbname < dumpfile.sql I'm combing through the docs, but still don't have a clue.
View Replies !
Could Not Get MySQL Running
I went to MS-DOS to start the MySQL application by typing mysqld into the bin directory of where I installed MySQL but once I did typed the command and pressed enter this is all I got : A moment passed before I am shown the path of bin with no indication of MySQL server started. And also I have installed this as a window service.
View Replies !
|
TRACKER
