Is Replication Is Possible B/n Two Mysql Running On Different Ports On Same Machine
I am running two mysql in my system with different ports, is replication is possible with two mysql running on different ports in same system?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
How Do I Create A Database On Linux Machine Running Mysql?
I have an sql script file that is supposed to create a set of database tables for me. Supposedly I type the following on my linux box and its all supposed to work... mysql (ENTER) . mysql_dump.sql.txt When I type myslq <ENTER> I get a command prompt that looks like this... mysql> But I don't know how to change directories from that command prompt to the directory where mysql_dump.sql.txt is located. Can someone tell me how to change dirs at the mysql> prompt?
Is There Anyway To See Ports And See What Is Connected?
Got mysql started, created root password. Decided to change it and used mysqladmin to try and change. It says access denied. I tried to stop the service, can't do that. I even restarted the computer and it says there is still a connection on localhost:3306 and it can't make changes. I have deleted mysql and completely re-installed. Nothing changes. How can I completely stop the service that it tying up :3306. Is there anyway to see those ports and see what is connected?
Random Ports
mysql 5.0 was working fine in Debian "etch". Then I installed awstats, which changed something somewhere and now the server starts on a random port. However, no clients can FIND it! How do I resolve this issue?
Listening On Two Ports (3306, 80)
my customer is not able to connect to MySQL Server on port 3306.So i need to change this to port 80. But other standard applications also should connet to this Server and they should use port 3306. How i can configure this?
Migrating My Mysql DB From One Machine To Another
We are moving our mysql db from one machine to another -- both linux. Origin machine is running mysql 3.23, destination machine is running mysql 4.1. Can we simply copy all *.MYD / *.MYI / *.frm files from one machine to the other and have things work? Or do we *NEED* to do a text dump of the tables, and reload each one individually on the new machine?
How To Go About Re-installing MySQL On A New Machine?
I have MySQL installed and a database already built and loaded with data that is collected nightly from the mainframe database. I am currently running on NT and will be loading a new image onto the machines to change the operating system to Windows2000. From what I understand, I will need to copy all files I want to keep, including my database. My question is, once the new image is on, I will need to re-install MySQL, is it as easy as just copying back the MySQL directory back onto the machine and the database still work? If not, can someone tell me what the general process is to do this without losing the database and any issues that I am going to run into?
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.
Connect To MySql From Another Machine
I have RHEL 4.0 installed on a x86 box, and am using the standard MySql server that comes with RHEL 4 (MySql version 4.1.12). I tried downloading the Administrator tool, but had problems installing it. (This issue has already been reported at http://forums.mysql.com/read.php?34,65093,65093#msg-65093). I have an Administrator install on a Windows machine, and I want to use it to connect to the MySql server on the RHEL box, but get the error that says: Host '<my_machine>' is not allowed to connect to this MySql Server. Can I use the Windows Administrator tool to connect to a MySql server on Linux? (same network and sub-net) During the RHEL install, the firewall option has been disabled, so that's not an issue. I think I need to add an entrry somewhere in the MySql db that allows other machines to connect, but am unsure of how to add it, and what the syntax looks like.
Access MySQL From Another Machine
how do I make MySQL server accessible from the network to other web servers. Right now I have the MySQL server and the web Server all on the same server. But I want to have a server that is solely responsible for MySQL and 3 others servers that are responsible for web page serving via Apache. The web servers need to be able to access the MySQL database. |-----| |----| |----| |Web | |Web | |Web | |-----| |----| |----| ! ! ! !!!!!!!!!!!!!!!!!!!! | |----| |My- | |SQL | |----|
Usinq MySQL And MS-SQL On The Same Machine?
I want to try MySQL but I already have Microsoft SQL Server on my machine. Can they reside on the same PC or will they mess eachother up? And why does the name of this newsgroup start with 'mailing.'?
Usinq MySQL And MS-SQL On The Same Machine
I want to try MySQL but I already have Microsoft SQL Server on my machine. Can they reside on the same PC or will they mess eachother up? And why does the name of this newsgroup start with 'mailing.'?
Connecting To MySql On An XP Machine
I have worked with mySql on my localhost and it does fine. Now I am going to try and login to it from another XP machine. Both machiens are Windows XP Pro SP2. What do I need to type at the command prompt to login to mysql on the other XP machine?
Mysql Runs On A Machine With Multiple NIC.
When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of user@localhost instead it will be equal to the rights of the user@PrimaryIPAddress. Is this behaviour correct or a bug.
MySQL Administrator On A Remote Machine
On my internal network i have mysql running on a test/development webserver (windows), and im trying to use the GUI tool MySQL Administrator on another networked pc but it wont work. It keeps saying 'Error 1045 Access Denied....' I can ping it fine, and MySQL Administrator GUI works on the server itself.
Installing MySQL On WIN98 Machine
I'm trying to install mySQL on my WIN98 machine (I ran the setup.exe file), and am never prompted for a password when I run the configuration wizard. When I try to then run the command window, I'm asked for the password. Can I change some config file or ini file? I'm selecting either Detailed or Standard Configuration, and don't ever get the prompt for password. The checkbox for "Install as windows service" is disabled, so I can't check it.
MySQL VmWare Virtual Machine - Password?
I just downloaded and installed the MySQL-provided VMware linux virtual machine. To logon to it there is a linux user 'lxuser' provided. Anyone know the password for lxuser? root?
How To Insert Machine (local) Time In Mysql
This is a problem I encountered in mysql: how do I insert local (machine) time? To do this in MS Access, just put now(). I tried this in mysql, it does not work. see graph(the red chinese characters means the same thing as above.)
Importing MySQL Database To Local Machine
I have exported a MySQL Database from a remote server using PHPMYADMIN, saved on my local XP machine as an sql file to insert (with name _DB_.sql) but am not sure how to get this to run on my local XP machine which is running MySQL locally; When I view the file on Notepad it appears to be executable in some way as it includes CREATE command etc. I tried the following from MySQL command line SOURCE C:/Program files/MySQL/_DB_sql but can't see any evidence of the database having been created on my local machine.
Multiple MySQL Server Installations On One Machine
First, does MySQL architecture support the creation of multiple MySQL server installations on one machine? (Specifically, I am hoping for two different MySQL 4.0.12 servers on the same machine for two different departments with two different DBAs.) If so, what naming convention (and infrastructure) distinquishes between the two MySQL servers? What network connectivity file entries would exist to differentiate between the two servers such that I could connect to one or the other servers from a remote client?
Help Please Running Mysql On Os X
I am very new to mysql. I am using the sitepoint book 'Build your own Database Driven Website using PHP and MYSQL. I have installed mysql mysql-5.0.41-osx10.3-powerpc. Under preferences/mysql it indicates that the mysql server is running. When I try to access mysql through the terminal window I get a message - command not found. Or no permissions. I can go to the bin directory and list the contents - they seem to be there. I can't get past page 21/22 Post-installation setup tasks. I am also new to using the terminal window. I suspect I have missed something really basic - any suggestions on how I can get up and running would be much appreciated!
Need Some Help In Getting MySQL Set Up And Running.
I wasn't sure if someone would be able and willing to help me, but I am new to installing MySQL on a Windows 2003 server (actually .. any server), but I am installing it on a Windows 2003 server right now. I also installed a new version of PHP on the same server. Everything looks fine, but when I go to phpinfo.php I don't see anything saying MySQL. (I saw somewhere that if MySQL is installed properly, it should be displayed on the phpinfo.php page.) I am currently trying to set up and run Cerberus Help Desk, but it isn't finding the MySQL database that I installed. So, I would really appreciate it if someone could not just help me via email or postings in here, but actually by using Instant Messenger (AOL, Yahoo! or MSN) to walk me through the set up, testing, etc. so I can get things up and running properly. I was hoping that someone with more experience than I might be willing to help me in this manner.
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.
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.
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?
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.
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>
MySQL Is Running, But I Can't Connect
I really need some help with this. MySQL will not start on boot despite everything I've done to make sure that it is set to do so. When I start it as root from a terminal with "/usr/bin/mysqld_safe --skip-grant-tables &" I show several mysqld procs. and one mysqld_safe, but I can't connect: [root@adamsmdk madams]# ps -aux| grep mysql Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html root 3650 0.0 0.1 2276 664 ? S 11:09 0:00 /usr/lib/courier/authlib/authdaemond.mysql start root 3654 0.0 0.1 2316 792 ? S 11:09 0:00 /usr/lib/courier/authlib/authdaemond.mysql start root 3655 0.0 0.1 2276 664 ? S 11:09 0:00...............
Gdb Bus Error When Running App With Mysql 5.0
When linking with mysql 5.0 library, I can't no longer use gdb to debug my app anymore. It cores immediately with a bus error. I've also noticed that the size of the executable is more than doubled compared with one linked with mysql 4.0
Running MySQL In RAMDisk
Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP. Any suggestions or experiences?
Running Two MySQL Versions
Actually what I want to do is remove 4.1 because I downloaded 5.0 and installed w/o removing the previous version. I now have port 3307 for 5.0. Is this a problem and how can I change it back to 3306 so e.g. when I use Apache/PHP evrything works?
MySQL Running Very Slow
I have the following INSERT SQL, which runs very slow (For 2 full days it had not done anything) on a 2 processor Compaq machine running Suse Linux. Code:
On What Port Is MySQL Running?
I'm running MySQL on my Mac, and I'm trying to figure out on what port MySQL is running. What can I type into Unix terminal to figure this out? Or can I find out some other way?
Slow Running MySQL?
I'm hoping someone may have an idea what could be causing the slow loading pages of my web-site. I'm not positive, but I'm relatively sure that it's related to a problem with MySQL database. I purchased a program called Sam3 for broadcasting our radio signal over the internet. The software requires the use of MySql in order to set up web pages for our web site. The problem is, that while everything works GREAT (requests can be made from the site, songs can be searched, the history of what we've played shows up) the pages load PAINFULLY slow. Other users of this software have had no such problems so I'm at a loss. I know from testing that the PHP script for the web pages is fine, I have plenty of bandwith both upload and download available on my DSL line, and while the computer running MySQL is behind a router I have tried plugging the DSL line DIRECTLY into the host computer and it makes no difference. For all appearances it seems the problem is that it takes MySQL forever to gather and provide the information needed for these pages. Does anyone have any idea what I should be looking at to solve this problem? I do not know the MySQL program at all, so I get somewhat lost when people start throwing out technical terms, but this has been really frustrating because no one else seems to have the problem and everyone so far has just told me to check the things I've already checked.
MySQL Config Not Running
i'm trying to set up MySQL with IIS 7.0 on Windows Vista Home Premium. After you install MySQL, there's a check box to launch the config app. if i leave it checked, the app does not load. if i try to run the app by double-clicking its icon it gives me an error saying, "The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail." I cannot find the application event log, though.
Running Mysql From Shell
I need to run this sort of querys from shell: delete from 3dinformatica where preco = " " ; CREATE TABLE tudotest AS SELECT DISTINCT * FROM 3dinformatica; DELETE FROM 3dinformatica; INSERT INTO 3dinformatica (cr_datetime,produto,vendedor,preco,link) SELECT DISTINCT cr_datetime,produto,vendedor,preco,link FROM tudotest; DROP TABLE tudotest; i wanted to put the mysql cmd in a file like mysql.sh and run it from crontab. i have about 100 querys like that i need to run at the same time.
Running Mysql On Old Computers
IĀ“m running mysql on a Pentium 166 Mhz with 16 Mb of RAM. Pretty old, right? I want to know if there is a way to improve performance. I donĀ“t know, something about reducing the number of queries that it will respond or cutting out some features.
Running MySQL In RAMDisk
Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP.
Running Two MySQL Versions
It seems that my computer is running two different mysql versions. When I'm trying to login to the database it refuse my password and giving me access to the test configuration. This is what i get in the event viewer. Do you already have another mysqld server running on port: 3306 ? Event id 100. The problem occur when I changed my password for the database. I have turned off Mysql in local services but i think that that's the original version. When I start the xampp i think it starts the winmysqladmin version (not sure). How do I reconfigure the hole thing and how can I see what's running on my machine. I actually have another question to. I'm trying to run and open the shell mysqladmin which doesn't work. It's just a flash, which one of them am I supposed to run?? You have several options like mysqladmin, mysql, mysqld, mysqld-nt....etc. I opened the winmyslqadmin which i think wasn't that good.
Running Backup For Mysql
Can anyone suggest a reliable and inexpensive backup service for mysql? I have about 50 tables, of which I've been doing database backups daily on the server, then downloading the backup every couple days or so. The backup files are starting to get relatively large, and I'd like to find a service to backup to off site.
Running MySQL Win32
I'm an absolute beginner and would really like to read something in the manual to solve this problem, but the manual just take care of Unix and Linux users. Because we develop on NT we wanted to install MySQL with Apache and PHP3 on a NT workstation for faster testing beside our Linux station. But I have problem to start the program (mysql.exe). It just gives back an error: Error 2003: can't connect to MySQL server on localhost 10061 Network is running, I can ping localhost. I don't know what to do to get it running.
MYSQL Running Query On Data Through Php...
I am trying to take address info from 5 different fields in mysql, concatenate them into one string of text and have then run through a POST, like you would in a form, and have them spit out on the other end into the database the Lat and Lon of the address... I can do it manually, but I would like to do it automatically... I would like to know if I am going at this right... Psuedo QUERY=SELECT addressNumber, addressStreet, city, state, zip FROM table $addressStr=addressNumber + " " + addressStreet + ", " + city + ", " + state RUN IT THROUGH A POST SOMEHOW??? and call GEOCODER from my manual insert script... $sql=INSERT INTO table SET lat='$lat', lon='$lon'
|
TRACKER
