Migrating Mysql Servers Between Windows Machines
I just had to do a mass data switch to my windows server.It's been running apache with php and mysql for over a year now.
This data switch meant i just copied the files over to an almost exact copy of my current windows installation.Unfortunatly mysql didn't startup the way everything else did.Now the server won't start at all(dies on startup.) If anybody knows any problems that would probably result from migrating MySQL i'd be highly appreciative. Short of that,how can i find the errors mysql is having,thus allowing me to diagnose a solution the problem.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Sharing MySQL Install Between Multiboot Machines (windows)
On Windows, I multiboot W2k, WXP. All 2 have MySQL install but in different directories and partitions. I (unfortunately) also have 2 instances of one database. Is there a way for MySQL to share a common installation and database? I suppose it is possible. If so, and if I install MySQL in W2K first, what are the steps to import the database install into XP? Will I need to install in XP again, and just import the databases? Or just create a windows shortcut to database directory so it's automaticaly imported into XP MySQL?
View Replies !
View Related
How To Target 1 Of 2 Servers On The Same Windows Server
With the end of the year came the time to do upgrades on my server. I try to stay back a revision in conservative fashion. So MySQL 4.11 was upgraded to 5.0 then 5.1 on Dec 31st. We just found out that one of our clients sites can not work with 5.1 so we rolled back to 4.11 But MySQL allows you to run multiple SQL servers without problem on the same server. So 5.1 was reconfigured to run on a different port than default. Now I have phpMyAdmin with two configurations able to access both DBs. The question is, How do I target one DB or the other with my scripted pages? Connection string? IIS config based site to site or based on the ext like PHP files will use one port and .ASP files will use another?
View Replies !
View Related
MySQL ConnectorJ And Remote Machines
Let's say I have a MySQL 4.12 database, opened to the internet on 111.111.111.111 allowing all incoming and outgoing ports. I have a username and password setup, which CAN connect to this database, from 222.222.222.222. Also on 222.222.222.222, which is running Tomcat, I have a Java servlet, called, say, servlet.class in WEB-INF/classes. servlet.class has permissions 755, as does WEB-INF/classes. Additionally, I have on 222.222.222.222 under WEB-INF/lib mysql-connector-java-3.1.7-bin.jar also with permissions 755. The system (222.222.222.222) is running on Linux Kernel version 2.6.9-22.0.2.ELsmp. I am running Java 1.5.0_05. Bear in mind, the very same parameters, from the same machine (222...) connect to the very same db (111...) under php (so there is no firewall issue on 111...). Additionally, if I run a MySQL DB (version 4.0.25) on 222... and connect to it (thus, on 'localhost') I can connect no problem. It is only when I go to connect to a remote machine that I get the following stack trace: Code:
View Replies !
View Related
Replicating Mysql DB To Local Machines
We have an application written for a PDA that we are switching from MS Access to Mysql. There is a central server that has all the data in a mysql database, however when we sync from the PDA it is much faster sync'ing to a local copy of the mysql database then on central server (users are remote and must VPN into server). What are the options for taking a larger mysql database and segmenting out data for a particular user (a subset of total data) to their local machine? Is mysql replication a good option or is there some other technique?
View Replies !
View Related
Question About MySQL Performance On 2 And 4 CPU Opteron Machines
We ran MySQL (4.0.15-standard, 64-bit, SuSe 8.0) benchmarks on 2 CPU and 4 CPU Opteron machines. Mostly we tested insertion times with many simultaneous connections (hundreds). To our surprise we did not find significant differences. Each of our servers (2 and 4 CPU machine) has one 1Gbit network connection. I have feelings that the machines are the network bounded, not the CPU bounded. Could it be true? How to verify it?
View Replies !
View Related
Migrating 3 Mysql DBs Into One
i am about to embark on a replication project using mysql and slaves, at the moment i have three servers in three location working as a backend to a radius server. I am thinking of putting all 3 as one "Master Server" in a central point, and i would like to know how can i get all the datas from the 3 points into the central point?
View Replies !
View Related
Migrating From One Mysql Db To Another
I have a mysql database on a community site that is built on code I bought. In the last update issued I was told that the new db is not compatible with the old one and the only solution is to delete all of my members and start over again. Now, I'm just an old mainframe programmer, but this just doesn't seem to make sense to me. My question is this: if both databases are mysql, can I not use the mysql migration tool to move all of my member data from the old db to the new one? is this something that a newbie can do?
View Replies !
View Related
Migrating From Access To MySQL
I have an Access database that has served its purpose well but will not cut it in the future. Does anyone have any good suggestions or tutorials on MySQL? I need to know how to create MySQL tables and how to migrate my data up to my web server/host.And is all of this really difficult?
View Replies !
View Related
Migrating Asp/access To Php/mysql
I have a site running an online continuing education course, it was created as an asp site, using MS Access for the database. I'm attempting to transform or migrate it for use on my main e-commerce site which is hosted by a Yahoo merchant account. They only support PHP, and MySQL. They advise the installation of phpMyAdmin,on their server.I have tried this,but could not see a way to connect to it via ftp,or to create my database externally,I have read the documentaion, and am lost on it as well. I have determined that this is more complicated than I had origionaly thought,as I am getting confused. I run everything using Windows XP home addition, and use Dreamweaver 8,and connect via ftp to the servers.I have MySQL serer 5.0 installed on my PC. I have used asp2php and converted the pages,and have used MySQL migration tool for the database via PHP. NOW I'm lost,and can't decide exactly what to do next. Can anyone give me advice about exactly where to start,and what I need to install, or specific tutorials to read? I feel that I must first get the database established on my server,before attempting to correct any links for the PHP site to utilize it, and uploading them.
View Replies !
View Related
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?
View Replies !
View Related
Migrating MySQL Data
I recently got an application with MYSQL as the backend database. The database model designed for this application is bad. We have redesigned the model for the app. The problem is there are thousands of records in that old database whose table structure is completely different to our new design model. What can be the best approach to import that data exactly into the specified columns and tables into our new database. For Ex: The old database has several tables which are columns in the new database.
View Replies !
View Related
Migrating An MsAccess DB To MySQL
Well, as the subject of this post says, I want to convert a microsoft access database into a MySQL database. I'm already running Ubuntu 6 server with a LAMP installation. The MySQL server is already up and running and I've created some test databases. The Access database is located on a Windows server. I have full permissions to the Access database and the MySQL database. I'd like the migration to be as simple and painless as possible. Any recommendations on free tools to use?
View Replies !
View Related
Migrating Data Into Existing Mysql Schema Tables
i understand how to migrate data into mysql and to use the migration tool to convert a database to a mysql schema, however, I'm not sure I understand how to migrate specific data tables/columns in the source file to specific tables/columns in the destination mysql tables (where the schema already exists and I'm simply importing data itself).
View Replies !
View Related
2 Mysql Servers
I have a Mysql server lets call it "Production", but also do lots of development when traveling (offline) on my laptop, where i also have mysql instance installed + php + apache .... both MySql are 5 and same build running on windows. What would be the best way to "replicate" Mysql from my laptop to the server when I get connected. One way solution (from Laptop to Server) would be great, but both ways (whichever is newer gets replicated would be excellent). thought about replication but i undertood that the master 'version' will always be writen to slave. We need to consider any kind of changes, table changes, dbs change, users, data, etc... Hope you can give me a light, it is not a large amount of data, and i would not mind a very manual process, as long i can script it or if it is a few steps only.
View Replies !
View Related
Replication On 3 Machines
I have 3 machines M1 M2 and M3, i need to setup the following: M1 is the master M2 is reading from M1 M2 is a master for M3 M3 is reading from M2 the problem i got, is when i run a command in M2, it's replicated in M3, but when the command is being run in M1, it's replicated in M2 but not in M3.
View Replies !
View Related
MySQL Databases And 2 Servers
We are planning to reprogramm our search machine and website. Since we have call agents who query the same database as the customers do, we had the idea of splitting the database to 2 servers. The call agents can update customer data with our intern webinterface, which not only concerns tables that are for the call agents, but also concerns tables of the search machine, holding company data such as address, search words, etc. Since the customer himself can administer his own data, as well as the call agent (or media agent), I was thinking of doing following: * I have 2 servers. Server 1 is responsible for the search machine and just serves customers searching for a company or for products. The MySQL database is there just for querying. * Server 2 serves call agents, as well customers who want to change their data, reading and writing. * Since the search machine should of course show updated data the call agent or the customer have eventually changed, the data from server 2 must be synchronized with the MySQL databese of server 1. (e.g. at midnight) Questions: ------------- 0. Is the above described the right way? 1. What do I have to consider when planning the database structure? 2. How do I synchronize? Can I copy specific tables from one server to another using cronjobs (crontables)? Since this is absolute newland to me, how? Any expert knowledge or experience with MySQL replication or MySQL clusters? I think replication is just thought for mirroring, or am I mistaken?
View Replies !
View Related
Consolidating MySQL Servers
My organization currently has 2 different MySQL database servers. We are in the process of moving the databases from Server A to Server B and have Server B be our primary database server. I've done some research on the web and believe the best option is to use the "mysqldump" command to remotely recreate Server A's databases on to Server B. Can anyone please advise whether this is the best option? Also, using the "mysqldump" command, are there any overwrite issues, such as existing tables on Server B being overwritten by tables with the same names from Server A. Would these tables be simply overwritten or would there be any type of warning prompt?
View Replies !
View Related
One (phisical) DB And 2 MySQL Servers
Is it possible, that couple of MySQL servers wcan work simultaniously with one (phisical) DB? My task is following: I have to computers and thay both have one (and the same)å SCIS Raid harddisk. This all together shall be a MySQL Server. have can MySQL be installed so, that DB will be placed in one pace (SCIS Raid), and MySQL works simultaneously on both computers. what concerns MySQL Cluster, as much as i've understood it is designed to store one DB in different places - distributed by cluster nodes. It is too much for me, isn't it
View Replies !
View Related
Several Mysql Servers On 1 Machine
Is it possible to setup 2 mysql servers on a Linux platform? For example, both are listening on different sockets. They have different processes, working directory, setup directory. I've seen the my.cnf on my machine but I can't see any socket number.
View Replies !
View Related
Two MySql Servers, One Database
I have two MySql servers, one in my local PC and one as a testing server in the next room. Using DW 2004 I can use the "put" and "get" to get my PHP files from one PC to the next quicky. How can i do that with the two MySql servers? So if I change the Structure of a table or and data to the Mysql database on my local PC, it will send the changes to the testing server.
View Replies !
View Related
Replication With Multiple Servers In Mysql ?
I want to establish replication between multiple (currently three) servers. Updates/inserts/deletes may happen on all of them. The idea I came up with was to do a "circle"-replication. The problem with this is, that if one server fails the rest may not get updates (until the server is back, obviously). Does anybody have an idea how to establish such a replication in a fail-save manner ? Code:
View Replies !
View Related
Replication With Multiple Servers In Mysql
I want to establish replication between multiple (currently three) servers. Updates/inserts/deletes may happen on all of them. The idea I came up with was to do a "circle"-replication. The problem with this is, that if one server fails the rest may not get updates (until the server is back, obviously).Does anybody have an idea how to establish such a replication in a fail-save manner?
View Replies !
View Related
Two MySQL Servers Share Data
Is it possible to have who MySQL servers contact eachother at a certain time intervul and send data to each other? For example: Mysql A is empty. Mysql B is used for all kinds of things. I want Mysql B to send certain tables to Mysql A every 5-10 minutes.
View Replies !
View Related
Installing Multiple MySQL Servers
If you need multiple MySQL servers running, what's the difference between installing MySQL once and running multiple servers (by issuing multiple mysqld commands with their own options), versus actually installing two or more DIFFERENT instances of the same version of MySQL? What is typically done? What are the advantages/disadvantages of either method?
View Replies !
View Related
Detecting MySQL Servers On LAN's
I want to build a script/app to make an inventory of all computers that run MySQL servers. And if possible return their versions. I would be running this script/app from a Windows system, so I would like to use VBScript or Visual Basic 6.0. This way the people I am working with will be able to understand what I am programming too. Further more it would be nice if I couldn't only detect the Windows machines, but also other systems (mainly Linux). Can this be done? And how?
View Replies !
View Related
Apache & MySQL In Differentes Servers.
I've been running a slow Debian machine, with Apache + PHP + MySQL. But, with the time and usage, it's getting to slow to use MySQL. So, now I have another machine (running Debian too), and i've installed MySQL there with all the databases and users moved on to, it works perfectly (with phpmyadmin). What I want is to have the first machine running apache + php, and in the other MySQL. How can i do that ? I've tested making a mysql_connect from a page hosted in the first machine to the other one running MySQL but i didn't work, couldn't connect. I've tried redirecting mysql port to the other machine (iptables) and that didn't work either... Resuming... I want all my users to work with the first machine, they have their accounts in there and all their files, their pages, etc... And the database running in the other machine.
View Replies !
View Related
Subtraction Of Times Inconsistent On Different Machines
query structured as follows: SELECT time(c.start_time), time(c.end_time), time(c.end_time) - time(c.start_time) as 'opening_hours' FROM my_shop c; The data in start and end time is 1970-01-01 09:00:00 and 1970-01-01 17:00:00 respectively. On my local machine this this query returns: | 07:00:00 | 19:00:00 | 12 | However on a remote machine (production) it is returning | 07:00:00 | 19:00:00 | 120000 |
View Replies !
View Related
Changing Servers With Lower Mysql Version
I am trying to change servers and the new server is hosting a lower version of mysql therefore giving me errors when trying to import db. The dbs are for postnuke and here's the error I am getting: Error > SQL query: > > -- phpMyAdmin SQL Dump > -- version 2.8.2.4 > -- http://www.phpmyadmin.net > -- > -- Host: localhost > -- Generation Time: Oct 04, 2006 at 12:33 PM > -- Server version: 4.1.21 > -- PHP Version: 4.4.2 > -- > -- Database: `betweent_business` > -- > CREATE DATABASE `betweent_business` DEFAULT CHARACTER SET latin1 COLLATE > latin1_swedish_ci; > > > > MySQL said: > > #1064 - You have an error in your SQL syntax. Check the manual that > corresponds to your MySQL server version for the right syntax to use > near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line > > I know a little about mysql, but not enough to mess with this... > > New version: MySQL - 4.0.27-standard > phpMyAdmin - 2.8.0.2 > > My old version: MySQL - 4.1.21-standard > phpMyAdmin - 2.8.2.4
View Replies !
View Related
[ERROR] Table Mysql.servers Does Not Exist
have installed WAMP 2.0 and everything seems to work fine. I am learning PHP and MySQL. I am also using hMail server to send mail. Everytime I try to send an email using a PHP script I get the following message (Error querying database). This is what I get in the MySQL Log: 090218 16:50:35 InnoDB: Started; log sequence number 0 46409 090218 16:50:35 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 090218 16:50:35 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type
View Replies !
View Related
Mysql Sql Access 2 Servers In Single Statement
Is it possble to access databases in 2 server simultaneously in sql using the mysql client? I can use sql to access multiple dabases on the same host1 server when I run 'mysql -h host1' but I cannot find a syntax to access databases on another server, which is supported on other db software.
View Replies !
View Related
Moving MySql From Development Server To Other Servers
I am using Dreamweaver with php, mysql and Godaddy for Hosting. I have a website developed that runs fine locally using the localhost for both the Web app and MySql. What is the process that I go to to move or export the databse from the development server to Godaddy's MYSQL server. I have not found an "export" function using MySQL Adminstrator, or MySQL Control Center.
View Replies !
View Related
Compile Data From MySQL Tables On Different Servers
I'd like to retrieve data from MySQL tables on websites A, B, and C, to display on website D -- is this possible? Basically, from site D, I'd like to compile the last entries in specific tables in sites A, B and C, and show them on a "summary page". Do I need to import the data into a local (site D) table, or can I retrieve the data from A, B and C on the fly?
View Replies !
View Related
|
TRACKER
