Replication On Linux / Windows Operating System
explain abt how to do Mysql 4 replication on linux/windows operating system,
View Complete Forum Thread with Replies
Related Forum Messages:
Operating System Error
I have inherited some linux servers running mysql at my company from a prior administrator and have ran into a few problems. For some reason my mysql server daemon stopped running unexpectedly. I attempted to start the daemon with the mysqld command a recieved the following error. 070917 10:22:33 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. I also found another command to start the daemon in some sort of safe mode and it shows the followin error: Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/mysqlsrvr.pid 070917 10:20:46 mysqld ended I have checked permissions on pretty much every directory I could think of but still I get this error. Can someone please help?
View Replies !
MAXDB Operating System User
I'd like to use MaxDB on Linux Red Hat 8.0. I've installed correctly the software. But when I try to create a new instance through the WebDBM or the WinDBM GUI I've the following error : "-24875 The operating system user is not a member of the database administrators group. [user_system ...]; 149,UNIX password missmatch" In fact, I've checked who is the file /etc/opt/ [Globals] IndepData=/usr/local/maxdb/data IndepPrograms=/usr/local/maxdb/programs SdbOwner=maxdb SdbGroup=maxdb So I presumed that logically I can connect on Maxdb with the user maxdb or with someone who belongs to this group. But It doesn't work. When I try to use the text UI dbmcli, I can create the desired database instance. I've already searched on the Internet a solution but it might that some people have the same problem and it hasn't been solved.
View Replies !
MAXDB : Problems With Operating System User
I'd like to use MaxDB on Linux Red Hat 8.0. I've installed correctly the software. But when I try to create a new instance through the WebDBM or the WinDBM GUI I've the following error : "-24875 The operating system user is not a member of the database administrators group. [user_system ...]; 149,UNIX password missmatch" In fact, I've checked who is the file /etc/opt/ [Globals] IndepData=/usr/local/maxdb/data IndepPrograms=/usr/local/maxdb/programs SdbOwner=maxdb SdbGroup=maxdb So I presumed that logically I can connect on Maxdb with the user maxdb or with someone who belongs to this group. But It doesn't work. When I try to use the text UI dbmcli, I can create the desired database instance. I've already searched on the Internet a solution but it might that some people have the same problem and it hasn't been solved.
View Replies !
Which Is The Right Directory To Backup MySQL Database On Linux Opearing System?
Implemented web application using MySQL to maintain inventory of the office PC's/laptops/Routers/hubs and other stuff, here we are using MySQL as back-end Database on Linux Operating system. I need to backp all these Inventory database into CD/Tape/Floppy, which is the right directory (MySQL database) to backup (incase if the current MySQL server crashes, then I should be able keep copy of my inventory),
View Replies !
Windows Vs Linux
We currently run our MySQL on linux. Could someone advise me on the watch outs on moving MySQL to windows and also if there is any performance loss as a result?
View Replies !
Using Database In Windows By Linux
I am hosting an intranet on a machine with dual boot in both win98 and RH9 Linux. the intranet was first set up and running in win98. I have a mysql database in the win98 . The win98 partition is mounted in Linux and is accessible. I am duplicating the intranet in Linux. the HTML pages are accessing from the win98 partition. Is there a way to use the database as such by the intranet in the Linux.
View Replies !
Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error. [MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server Is it likely that the windows-linux combination is causing a problem here?
View Replies !
Replication On Windows
I want an urgent help for mysql replication running on 4.16 version does replication works on windows or linux only if it is pls give me minimal steps just first to start it replicatiing.i want it on windows box.
View Replies !
Updates Invisible - Windows Only (Linux OK)
I have one Java app writing records to a database (App A) and another, a Java web application running under Tomcat, displaying the records. Call this App B. When I first log into App B and get a connection, all records in the database at that point get displayed OK. But after that, any new records inserted by App A do not get displayed when I refresh (running the query again). If I log out of App B and log in again, getting a new conection, I see all the new records. This behaviour only occurs if I'm running on Windows. If I run the database on my Linux box with the same application code, new records inserted by App B are immediately visible to App B with no need to close the connection and open a new one.
View Replies !
Connection Problem !!! Windows To Linux
I wrote a program application for windows which can add and delete data from this application, it working fine with my own MySQL install on the same windows OS.. Now I try to change the connection this dayabase to the server whihc runnign under linux, and create the same database, same user and password. But when I connect the error message said: [MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to connect to this MYSQL Server. But form the database, I added the host "%", means hsould be allow any host... anyone can help me on this? the application I wrote will be using with dynamic IP everytime user dial-up to the internet connect.
View Replies !
Is MySql Syntax Different On Windows Vs. Linux?
On our team, we're working on a database. One copy is on the PC. The other copy is on Linux. I wanted to send a new table to the Linux guy. I went into MySQL Query Browser, did a "Copy CREATE statement to clipboard", and pasted the SQL code into a new email and sent it to my Linux guy. He tells me that the code fails every time. Here's what It looks like:
View Replies !
Slow Connect Linux To Windows MySql
I have a Linux box with the latest MySql and another box (Windows 2003 Server) with the latest Mysql. From the unix prompt I do this: mysql -uroot -pmypass -h windowsserver mydbname this take about 4 seconds to connect I do the exact same thing on a windows workstation and its connected instantly.
View Replies !
Sharing Database Tables Between Windows & Linux
I'm new to MySQL (using v4.1) and have a dual boot machine with Windows and Debian Linux (Etch). My goal is to share a table named "wordpress" between Linux and Windows by storing it on a FAT32 mount (I realise this limits me to 4GB in total). From what I can see at the moment, the "wordpress" tables live under /var/lib/mysql/wordpress. Numerous searches have revealed how to backup data, but I haven't seen any clues on how to permanently reloate a database to another location.
View Replies !
Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system. I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle. Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!
View Replies !
Query Behaving Differently In Windows And Linux
I have a query to find the blog entries that are most commented: SELECT blog.*, COUNT(blogcomment.id) AS cnt FROM blog, blogComment WHERE blog.ID=blogComment.BLOG_ID GROUP BY blogComment.BLOG_ID ORDER BY cnt DESC The query works fine on my development machine running Windows mysql 5.0.22 but on my Linux server running the same version of mysql (5.0.22) I get the following error: #1054 - Unknown column 'blogcomment.id' in 'field list' Any ideas why it works differently on the two servers? Suggestions on a better written query is ofcourse welcome too
View Replies !
Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the site performance is very slow on windows. I dont know the exact reasons. I have seen some benchmark details on internet. But still they are not having concrete facts to support LAMP as a better alternative to WAMP. Allmost all the search done on google melts down to IIS vs Apache, My main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly for PHP/MySQL.
View Replies !
JOIN Issue On WIndows Install But Not Linux Install
I am using MySQL 5.0.15 on windows and cannot run this query: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25 I receive: ERROR 1054 (42S22): Unknown column 'a.createdby' in 'on clause' But this query DOES work under my linux 5.0.0-alpha! I can modify the SQL Statement to the following and it works fine: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id RIGHT JOIN building b ON a.sortcode=b.sortcode WHERE a.sortcode like '1,2,1,6%' LIMIT 0, 25 .
View Replies !
Best Way To Delete Data From Operating Db?
I have a db that is moderately busy (a couple million records added over a day, 60-300 db hits per second, average about 120 or so). The database is in constant use and the server can't be stopped under normal circumstances. I need to be able to remove data from the db at periodic intervals, generally at least once a day, depending on the sizes of the tables. I've been doing this via scripts that first do a mysql dump for a date/time interval, then a delete for the same date/time interval (if the record numbers are above a certain threshold). I also do periodic checks and optimizes. At times this seems to have an adverse affect on the mysqlserver performance. I then split out the tables to be backedup and deleted individually, which kind of works. My main question is what is the best way to do this (i.e. backup and then remove data from an operating db) with the least impact on operation? I haven't seen any option for mysqldump to remove data, which of course doesn't mean that I haven't missed something like that.
View Replies !
Mysql Linux To Mysql Windows
i have been running mysql on rehl4 and now the powers that be want to move the databases to a central windows 2003 server running the windows version of mysql. how on earth do i import my dump file in the window version? i am familiar with doing it in linux but i cannot figure out the mysql command line tool that comes with the windows package.
View Replies !
Windows 2003 To Windows XP Pro Secure Communications...
I have a Windows 2003 Server running a Coldfusion app that needs to constantly update a MySQL database on a Windows XP Pro machine. These machines are not on a LAN and are physically separate. I'm trying to find a way to establish secure communications between them since I do not want port 3306 open to the entire internet. What I've Tried So far I tried CopSSH with Putty but this did not work because I need to manually initiate all sessions and enter passwords by hand. Since there aren't any SSH solutions that allow persistent, automatic connections, it appears I need to go with VPN. The VPN Dilemma I tried creating a VPN server on the WinXP MySQL machine but I cannot get ODBC to work remotely. How do you get the ODBC on the local (Win 2003) machine to recognize the MySQL database on the remote (WinXP Pro) server? Note: I also understand that getting SSL working on Windows is a pain in the butt. I'm trying to steer completely clear of that. I don't have the tools to recompile, etc.
View Replies !
POS System
I am working on a project to develop a POS system. The hardware, pda with barcode scanner, was chosen and i would like to ask how can those data in pda to synchronize the mysql in linux?
View Replies !
System Variable.
i am running mysql version 4.0.16-nt. now, i am connected to the server and i build some tables etc etc. everything is fine. i run the command "show variables". it executes fine and shows me the values of all the variables on the server. now if i try and change the value of the variable tmpdir using the set command, it tells me unknown "error 1193: system variable tmpdir". help needed here........ another point, the variable "tmpdir", points to the dir c:/windows/temp. i put a text file in that dir and try to load some data from that file into a table, and i get an error "file not found".
View Replies !
System Variable
i am connected to the server and i build some tables etc etc. everything is fine. i run the command "show variables". it executes fine and shows me the values of all the variables on the server. now if i try and change the value of the variable tmpdir using the set command, it tells me unknown "error 1193: system variable tmpdir". help needed here........ another point, the variable "tmpdir", points to the dir c:/windows/temp. i put a text file in that dir and try to load some data from that file into a table, and i get an error "file not found".
View Replies !
Booking System
Hi, does anyone know of a site (tutorialised / open source) that offers a PHP-MySQL Online Booking System (similar to a Hotel Booking System)
View Replies !
System Configuration
I'm currently rebuilding my home system - a couple of linux boxes with Debian. Although I don't have a high load on any of my systems, I am going to set up a separate box with my mail server and another for my web services. I'm wondering if there is an arguement for or against putting MySQL over on the mail box or even putting it on its own box?Assuming the arguement is for putting MySQL on a different box, are there any pitfalls, tips, tricks I should consider before starting this project?
View Replies !
Scoring System
Im sure some of you have come across 'neave' games? The scoring system is setup as below: CREATE TABLE games_pacman ( name VARCHAR(20) PRIMARY KEY NOT NULL, score INT(11) DEFAULT '0' NOT NULL, ip VARCHAR(15) ); CREATE TABLE games_banned_ip ( ip VARCHAR(15) PRIMARY KEY NOT NULL ); Clearly, it is possible to ban ip addresses from using the score system. But, can anyone tell me please if it is possible to set it up to ban certain names from being used?
View Replies !
Voting System
*********************** | game_id | discussion_id | *********************** SELECT game_id, discussion_id, count( * ) FROM `games_voting` AS votes GROUP BY votes.game_id, votes.discussion_id using the above query to generate a count of votes grouped by game and then user who got the votes right now it returns all the users that received votes for each game, i'd like to only receive the user with the top vote count
View Replies !
System Log For Triggers
Is there a system log file which can be checked to see the histroy of triggers. I am trying to debug a trigger that is not executing when it should.
View Replies !
Registration System
I have my database and HTML forms made. When I click submit to submit the registration it doesnt go to to the database it comes to a page with all of my database stuff on it. Can someone help? I have the page register.html made with the forms on it. When you click on submit its supposed to go to register.php which will send the info to the database. But is doesnt. Here is the register.php code:
View Replies !
Use This Database System?
I have just downloaded 5.1 and have been following the MySql book by larry Ullman. I have several question in regards to this database. First I would like to know if this is considered a back-end system. I have used ms access before and know that you can print all types of reports and forms to enter data. Is that the same with the mysql. How do business really use this database? Creating a table and colums can be very long is there a way to do this faster. I guess my main question how can this database be utilized besides for websites etc.
View Replies !
System.OutOfMemoryException
sql 2 error: Exception of type 'System.OutOfMemoryException' was thrown. this is the error I am getting using Mysql connect and Visual Studio. My program is set on a loop and after the program has opened and closed around a million connections in my error logs i see this error about 80 or 90 times then it gives me a timeout error until I stop the loop. If i try to restart it it will continue to fail unless I restart the computer containing the database. Does anyone know what is causing this or how I can fix it? Edited 1 time(s). Last edit at 07/18/2007 12:39PM by Joe Gates.
View Replies !
System Error: 113
I've been using MySQL and PHP for serveral years now. Recently we moved our mysql host to another host. Now this is how our system is setup. We have a VPS (Virtual Private Server) in Romania on which MySQL is running on port 3306. Our HTTP host is in USA and we connect to the MySQL server via this script: include("MySQLConfig.php"); // connect to the mysql server $link = mysql_connect($server, $db_user, $db_pass) or die ("Could not connect to mysql because ".mysql_error()); // select the database mysql_select_db($database) or die ("Could not select database because ".mysql_error()); The MySQLConfig.php is this: $server = XXX.XXX.XXX.XXX:3306 $db_user = our user name $db_pass = our password $database = name of the schema we want to connect to. The problem is we get this error: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /home/absoluti/public_html/ProcessRegister.php on line 62 Could not connect to mysql because Lost connection to MySQL server at 'reading initial communication packet', system error: 113 No idea what is going on as this has not happened before.. The script we use have been working before it just happened now after moving MySQL host and setting up with the latest version of MySQL :S can anyone help please? Thanks. -Arosh
View Replies !
System DSN Settings
We have an excel spreadsheet that contains macros to connect to a mysql DB (eroDB) via the ip - 192.168.1.50. the name of the dsn is 'auto_pny', username - dbr, password and all these other details are already defined in the system dsn area. when we try to execute the statement within excel, the connector/odbc popup keeps appearing with a different set of login credentials filled in (i.e. instead of server - 192.168.1.50, it has 192.168.4.67, user - pny ...) I have to change this everytime we need to exceute the query. Is there a way of changing a setting so I don't have to keep doing this all the time?
View Replies !
Getting System Date
I was wondering how to set up table to column to get the system date for a date stamp. Could someone help me with this. I tried date date SYSDATE with no luck
View Replies !
Best Way To Set Up Membership System
My site will have users that sign up and can then become part of multiple groups (think similar to Yahoo Groups or something like that). How would be the best way to set up the database/table structure so queries could be run to find both all the groups that a user is a member of and also get membership lists for each individual group?
View Replies !
System Tables
When I create a new DB it's empty. Are there a base set of system tables / functions and so forth created?
View Replies !
System Tables?
Is there documentation on the system tables? I couldn't seem to find anything when I did a search on system tables. I know about the information schema, but I want to know about the tables the information schema uses to build the views it contains.
View Replies !
Rating System
i want to do a rating system like youtube's where it averages out the total ratings. i'd store each of the ratings per each row and have them seperated by comma's then in my code put them in to an array. i also wanted to store the usernames of the voters in the database in the same fashion (without displaying them though) as above say instead of using cookies (as they can be deleted). would method this be feasible? or would this say overload the database and cause slow down?
View Replies !
|
TRACKER
