How To Backup/restore To Move Databases From One Server To Another (Win2k3 Enterprise, Mysql)
I'm trying to move a "schema" (I guess thats the term) aka database from our webserver2 to our webserver3. I backup the .sql file, and move it over to webserver3. I tell it to restore that file and create the database if it does not exist. Part way thru i get all these errors like: Code:
View Complete Forum Thread with Replies
Related Forum Messages:
How To Backup Databases When You Can't Reach The Server?
Ok, so since like 2 hours ago my local MySQL Server on my laptop won't start up anymore, when I boot the WinXP system I get a critical memory reading error from mysqld.exe and have to close it. And everytime I try to run the MySQL service, 5 secs later I get the error. Now I want to backup the database, but can't since phpmyadmin can't reach the mysql server. Is there any other way I can backup the DB?
View Replies !
Ugrading Win2k Server To Win2k3 Server
I would like to know if there is anything I should watch out for or do before I upgrade my Win2k server to Win2k3 server. I am running MYSQL version 5.0.27 and PHP 4. Which I must admit was a bit of a challenge finding the right combinations of the 2 that work together very well for my setup.
View Replies !
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
View Replies !
MySQL Enterprise Server With InnoDB For Mission-critical Data?
However recently the company I work for has the requirement to upgrade their database system. The data here really is mission-critical and we can't afford to loose any of it, and we need 24-7 uptime, with good performance (we have lots of clients so there'll be heavy load), any downtime will cost us. What I'd like to hear is peoples own experiences with MySQL Enterprise, good or bad, and if it's up to the job. Looking around the net I've seen lots of supposed expert DBAs saying that there's no argument; you should go with one of the "big 3", these being DB2, Oracle or MSSQL. However I get the feeling Oracle and DB2 would be a massive task to configure, and MSSQL - well it runs on Windows, we can't have any downtime no matter how good people say it is these days. So my idea was; InnoDB on 3 servers - a master and 2 replication slaves, with one slave off-site down a 10Mb line (wide enough pipe?). We use the on-site slave to run our daily backups, and point our reporting web sites at it too. the off site is for worst-case scenario disaster recovery. How much would we be better off spending more £ on one of the "big 3"? Would our data be safer on these? Would we get better performance with these? Is there a better model I could use for the MySQL setup?
View Replies !
Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup. The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information. I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration. I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.
View Replies !
Mysql Backup And Restore For 4.1.x
I have mysql 4.1.11 on my current server, i need my database restore another server.. (another server mysql version is 4.1.11 same.) And now... I just created new my database to new server following command: CREATE DATABASE dbname DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci; because our database and tables uses latin5 and turkish_ci collation. How can i get correct backup and restore for this character sets? example; mysqldump -uUSER -pDBNAME > /path/backup.sql and restore; mysql -uUSER -pDBNAME < /path/backup.sql is this correct for me? OR mysqldump --default-character-set=latin5 -uUSER -pDBNAME > /path/backup.sql and restore; mysql --default-character-set=latin5 -uUSER -pDBNAME < /path/backup.sql some peoples suggest me --default-character-set= variable for mysql 4.1.x backups and restore, is this correct? also if we backup database --default-character-set option, restore command is same option will need to use?
View Replies !
Mysqldump From Server To Server OR Move Folder /var/lib/mysql?
I need to move db's from a live server to a new server. The new server will be replacing the existing server once it's setup, and I need to move the DBs in order to do the testing. My question is this; if I use mysqldump to get a dump of all the DBs on the existing old server, and then import that .sql file to the new server, will that copy over *EVERYTHING* i need to get the DBs working again? Privilages etc ? The alternative that I am considering is to move the /var/lib/mysql folder along with mysql.cnf. That should work, as we can change any locations in the mysql.cnf file, but it does mean taking the server offline while we tar the databases, which could take 30 mins or so.
View Replies !
Restore From Backup With MySQL Admin
I am trying to restore a mysqldump txt file to another cpu using MySQL Admin. I receive an error: The selected file was generated by mysqldump and cannot be restored by this application. I understand there are other ways of transfering a database to MySQL on a different cpu. ie. mysql -u Username -p DBname < Filename.sql When I try this it doesn't work I'm doing something wrong. Does the "filename" need to be an exact path to the file or just the file name ie. C:folderfolderdatabase.sql Also does it matter if the file is .txt or .sql? Does it matter where I have the database.sql file on my computer? Do I need to have a new empty database created?
View Replies !
Safe Backup/restore In MySQL
This is my 1st post on this forum and I am a complete newbie to MySQL. I have installed MySQL 5.0.67 on Win XP Pro. I am using MySQL with some web based application. Which has stored data in MySQL. I am looking for safe backup technique. 1: Cold backup: What folder/files needed to be copied for cold backup? And can I restore these folders on other machines with same OS and MySQL version? 2: dump exp/imp? How can I exp/imp MySQL database into my machine and on other machines. Finally: Which one is better: Cold Backup or imp/exp dump?
View Replies !
Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only?
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar. Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
View Replies !
Copy/move Mysql Data From Local Machine To Remote Server Database
I have an website that is host on web server and here have a database that have only one table name is "user" Table fields are: name Id no email phone And I am using same site in my local machine. I always use my local machine for data entry and everyday end of the day I want to transfer data by clicking one button from my local machine database table to my remote server website database table. How can I transfer data from my local machine database table to my remote server website database table.
View Replies !
Backup/Restore
Working on a single machine (win2k) needing to do backups. Trying Backup Table with the following syntax: BACKUP TABLE tbldealers TO 'c:mysqlackups' BACKUP TABLE tbldealers TO /mysql/backups I've tried with/without quotes, ticks, nothing except the path. I either get error in syntax, or I do get 1 row in set, but there are no files in that directory. I've read the manual as extensively as I know to and can't find anything on backup table syntax. I'd prefer to stay away from mysqldump and mysqlhotcopy and control the backups myself.
View Replies !
Restore A Backup
I have made a backup of my phpbb forum db. For some reason I can't get it restored. I'm running my own server on linux, the only thing is I'm new to this too. lol I was wondering if there's a way to transfer ther MySQL file and just have it merge itself into the MySQL system? I have access to the console if that helps. Sorry if I sound confusing.
View Replies !
Restore Backup Sql
If I backup the database using shell> mysqldump --all-databases > all_databases.sql How do I restore it? Mysql documentation only mentioned below: shell> mysql db_name < backup-file.sql This is only to restore one databas, not ALL databases I wanted. My guess would be shell> mysql < all_databases.sql Is that correct?
View Replies !
Backup And Restore
Here is the error: D:>type *.bat backup_test.bat mysqldump -u root -pbow -r test200820.sql test restore_test.bat mysqlimport -u root -pbow test test200820.sql D:>restore_test.bat D:>mysqlimport -u root -pbow test test200820.sql mysqlimport: Error: Table 'test.test200820' doesn't exist, when using table: test200820 D:>
View Replies !
Quality Of Backup And Restore
I am using mysql administrator to perform scheduled daily backups of my employee database. What guarantee do I have after doing a restore that everything has restored correctly? My boss want wants a log of the number of employees in the database to be created at backup time (eg: 4388). Then after restore we should manually check that the number of employees in the database is the same (= 4388) to give us confidence that everything is back as it was. I believe this approach sounds terribly antiquated (back from the days of mainframes) but without something better what confidence do we have? In any case the backup is automated in mysql administor so how could I create this log of the number of employees at backup time? I don't see how I could. As a less important question my boss also wants scheduled backups at 12pm and 5pm daily but mysql administator only supports one per day I understand. Any ideas?
View Replies !
Backup/Restore To Web Host
I'm migrating a web site from my testing system on my local machine to the web host upon which it will live. My testing server is running MySQL v. 5.0.22, and the remote host is running 4.0.24. I am using MySQL Administrator v. 1.0.10 to run a backup and export my tables to an SQL file, and PHPMyAdmin to import the SQL file and run it on the server. At first, I was getting a 1065 - Query is Empty error. After reading through some of the postings here, I realized that some of the commented strings at the top of the file were unnecessary, and probably the cause of my error, so I removed them. I re-ran a backup that would only backup the appropriate tables and write the appropriate data (the database schema on my server is named differently, so I don't need to back up the full path). After editing the file to remove the uneeded stuff, I recieve a different error message, regarding an error in the SQL syntax of the dump file. The error in question occurs on a line that reads as follows: )ENGINE = MYIASM DEFAULT CHARSET = latin1; The error in question is as follows: #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 CHARSET=latin1' at line 21 I'm having a hard time finding the issue, and would really appreciate if somebody might point me in the right direction to help me create a backup file that my server will interpret charitably and restore the data I need. I'm getting to the point where I may have to re-enter it all by hand, and that thought depresses me quite thoroughly.
View Replies !
Backup And Restore Greyed Out
I installed the MYSQL administrator, and created a new database with some tables. I want to create an sql dump of this DB now, but all functions in backup and restore are greyed out in the Administrator. This is quite a silly question and problem, but I don't see what the problem can be. (I logged in as root).
View Replies !
Backup And Restore Database
i did a backup of mysql database using the command line utility mysqldump. this is the command i used "mysqldump -u root -h <hostname> --databases <dbname> > <backupfile> when i try to restore this using mysql command line client it gives a error after some time the message says that a error has happened on a line number and it states that the table columns does not match the values in the insert statmenet. i havent done any cahnges to the backup file i just dumped and restored thats all but when i tried this with mysql administrator gui tool it worked fine.
View Replies !
How Do I Do A Complete Backup/restore
I have a mySQL database on an ISP site that I am using. Now, I need to move the complete database to another ISP. I cannot use command-line execution. I do this all of the time with SQL Server and Access databases, but I can't figure out how to do it with a mySQL database.
View Replies !
Restore 50mb Backup
A customer passed me her backup, for me to open in my MySql. They are 50Mb of backup. MySQLAdministrator is being long a lot, very even to make the restoration in my machine (1kbps!!!!)
View Replies !
Backup And Restore Loads Of Db's
how would you go about backing up loads of databases (around 80megs worth) and then put them into another server. I can do a mysqldump --all-databases > myBackup.sql but i dont know how to get it back in on the other server? I did try exporting with mysqladministrator, but the linux system just closed the program when I tried to restore it (it worked hwen i tried it on windows)
View Replies !
Backup / Restore (from Windows To Fedora)
I have recently installed a Fedora server - something new to me. I am just trying to get my mysql database from my old windows server, onto my fedora box.I have tried, mysql_administrator to create backups and restore but it hasn't worked.I have also used the following two commands from root to do it: mysqldump -u charlie -p -h 10.10.10.3 --all-databases > /test.sql (to read from the windows server and create a dump on the local machine) followed by: mysql -u root -p < '/test.sql' (to try and resore the backup to the fedora box) I got the error: ERROR 1054 (42S22) at line 6854: Unknown column 'cl.COMPONENT_ID' in 'field list'
View Replies !
ERROR 1064 When Trying To Restore From Backup
Some time ago I installed MySQL on Debian Sarge ia64 and ended up with v. 4.1.11. I went on to build a database and a few days ago I wanted to copy it across to a web server, running Debian Sarge i386. I installed MySQL on the web server. As this was installed via FTP I was a bit pussled to see that I ended up with MySQL 4.0.24. Anyway, I thought no more about it, until I tried to copy across my MySQL 4.1.11 database. I backed up the original MySQL 4.1.11 database thus: # mysqldump -u root -p databasename > datavasename_bak.sql and encountered no problems. I also tried to restore it and everything seemed just fine. I then copied the backup file across to the web server and tried to restore it with the command: mysql -uroot -p databasename < databassename_bak.sql whish resulted in the following error message: ERROR 1064 at line 21: 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 CHARSET=latin1' at line 27 Having searched various forums it seems that this is a common error, but I have not been able to find any advice as to how it may be fixed. Just to make sure that there was nothing wrong with by installation I deinstalled the MySQL 4.1.11 version and installed it again (via FTP), which gave me a real surprise, as I now ended up with version 4.0.24. It seems that the Debian team has decided to go back to v. 4.0.24. I don't know why; I can only guess that there might be problems with v. 4.1.11. So, I now have compatible databases (booth 4.0.24) on the development machine and the web server, but I am left with an empty database and a backup (4.1.11) that I cannot restore. Is there a solution to this problem?
View Replies !
Restore Backup By Date Range
I want to restore the backups made in MySQL within a specfied date range. For eg I had taken backup between the dates 01/01/08 to 01/02/08. Now i want to restore it by specifying the date range as 10/01/08 to 20/01/08.
View Replies !
Backup / Restore (swap Drives)
I have this one FreeBSD box (nice Dell with one 40GB HDD). I have made a replica of the drive and put it on the secondary IDE channel. I want to do a restore of all the MySQL db's to the second drive right after the backup takes place from the primary drive. The reasoning behind this is that this is the only system running this particular app and the company that wrote it went belly so, I NEED to have the ability to just swap drives bring it back up and be done.
View Replies !
Get A 1064 Error When I Try To Restore A Backup
I am migrating my website from 1 server to another the versions of MySQL are as follows Old Server 4.1.14-standard New Server 4.0.25-standard I am restoring a Wordpress SQL backup using MyPHPAdmin version 2.6.4-pl2 and get the following error each time I try to restore Error SQL query: CREATE TABLE `ajones_Counterize` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `IP` varchar( 16 ) NOT NULL default 'unknown', `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `url` varchar( 255 ) NOT NULL default 'unknown', `referer` varchar( 255 ) NOT NULL default 'unknown', `useragent` text, PRIMARY KEY ( `id` ) ) 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10911' MySQL said: Documentation #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 ''ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10911'' at
View Replies !
Backup/restore User Accounts
I have mysql 5.0.14? installed. I need to make a fresh installation of 5.0.18 (no update). I can create a backup of my database (export) and import it into the new version. But how can I migrate my useraccounts? The probem is, I tried re-creating a user with same pwd in the new version, assigned privileges to that user and the user to my freshly imported database, but when trying to access the DB using a script, it tells me that "user" has no access.
View Replies !
I Need To Restore Data From My Backup Tables
I have installed Joomla and it created new database tables and took the existing ones and made them a backup. So I have one set that has a prefix of bak_ and the other set begins with jos_ How do I go about taking the data in the bak_ tables and inserting or copying it into the jos_ tables?
View Replies !
Restore Lost Databases
I committed the cardnal sin of computing, I upgraded MySQL without properly backing up my information. The new version couldn't find any of my old databases so I couldn't make a proper sql dump. I do however have all the folders with the original files/information associated with them. I tried just putting the database folder into the upgraded version of MySQL's data folder, but that didn't work. (I use phpMyAdmin for controling MySQL) I can see that there is a database by the name that I'm looking for, but when I try to view it, I get this error message: #12 - Can't read dir of './projectmcompanydb/' (Errcode: 13) figure out a way to restore this database? I'm using MySQL vMySQL 4.1.8 standard on OSX 10.3.9.
View Replies !
Restore DataBases To 2nd Hard Drive
Platform FreeBSD 4.9 on a Dell PC. I Ghosted the drive to a secondary disk and put it on the secondary IDE channel. What I want to do is, after the dump of all databases takes place, I want to temporarily mount the secondary drive and restore the databases to it. This would be a nightly proccess run by cron. I know almost nothing about MySQL and am not sure if this is even possible. I thought about doing the following script I wrote but, isn't there a nicer way to do this? mysqldump --opt --all-databases > /smx01/profile-mysql.sql echo "MySQL dump is complete......." ;; newfs /dev/ad1s1g mount /dev/ad1s1g /mnt/backups/ad1s1g cd /mnt/backups/ad1s1d restore -ruy -f /smx01/usr-local_dump1 /mnt/backups/ad1s1d cd umount /dev/ad1s1d echo Restore to secondary hard drive complete!
View Replies !
Restore Databases From Crashed Drive
Trying to restore some mysql databases that were on a hard drive which has crashed. Although the DB's were supposed to be backed up. It appears they were not backed up properly as I can access the drive but can only find the FRM files. There are no MYI or MYD files on the old drive. Is it still possible to restore my databases and tables with just the FRM files ??
View Replies !
|
TRACKER
