Restoring Backups From WindowsXP To Linux Ubuntu
I have MySQL tables on a WindowsXP box and backed them up then tried to restore them onto a Linux box. However, it doesn't seem to work.
I can find no trace of the restored files (there are no errors) on the Linux box even though the restore process displays as if it's taking place normally and successfully
Any suggestions?
View Complete Forum Thread with Replies
Related Forum Messages:
How To Use A Copy Of A MYSQL 4.1 Database In MYSQL 5 Running On Ubuntu Linux
We had a "permanent world" game server running on an older PC, under Ubuntu 5.10, using a MYSQL 4.1 database to store persistent data for the players, then the hard disk quit. We did back up our data on a regular basis, but didn't use MYSQL to do the backups, we simply copied the MYSQL/data/ folder to disk. So now we have a new hard disk, with Ubuntu 7.10 and MYSQL 5 installed. We have everything working, in that we have created the appropriate database and, using a simple test module of our game which will create some of the tables if they don't exist in the database, we can store and retrieve data from the database tables. The problem we have is how in the world do we get the data from the backup copy of the MYSQL 4.1 created database into the new MYSQL 5 database correctly? With 4.1 we could copy the contents of the database folder right into the database folder in the /var/lib/MYSQL/ folder, but this procedure didn't work with MYSQL 5. The files seemed to copy, as in the copy operation gave no errors, but we get an error that says the database is unavailable and to make sure the MYSQL server is running - it is, so we're stumped, and our game server is offline.
View Replies !
Php 5.1.6 With MySql 5.0 On Ubuntu 6.06
I am new to Ubuntu 6.06. I downloaded and installed apache 2.2.3 successfully on Ubuntu. I also downloaded Php 5.1.6. MySQL 5 is already loaded on my Ubuntu. When I tried to configure Php 5.1.6, I received the error: configure: error: Cannot find MySQL header files under /usr/local/src/php-5.1.6/ext/mysql. Note that the MySQL client library is not bundled anymore! i don't know enough about linux to know what is wrong. Can anyone provide help?
View Replies !
ERROR 1045 :: LAMP On Ubuntu
I have installed LAMP on an ubuntu machine. Now when I use the command: mysql -u memyid -p it gives me this error: ERROR 1045 (28000): Access denied for user 'memyid'@'localhost' (using password: YES) I did input the password that I set when installing the lamp package. But I do not know why it is acting this way... could some one tell me where I'm going wrong?
View Replies !
Odbc Problem While Hosting Mysql In Ubuntu
I am new comer in mysql, i have a code that is running well when i am using vb6 to accessing mysql database which is hosted in windows. But the odbc facing problem ( table "ttt" does'nt exist ) when i am trying to host the mysql database in ubuntu. I have trying to looking for the solution from google, but until the time of writing this thread, i got no solution.
View Replies !
Ubuntu Following Unix Post-installation Procedure
I'm following "2.4.16.2. Unix Post-Installation Procedures" in the manual. My OS is Ubuntu. I didn't have to initialise the grant tables because this was already done automatically during the install I'm sure. The reason I think this is that during install it asked me to set a password for root. Anyway, I'm up to step 3. It says to start the server for the first time I must execute the following command. shell> bin/mysqld_safe --user=mysql & so I got to /usr/bin/ and type "mysqld_safe --user=mysql &" I get an odd response. Here is what the command line interface looks like. bucephalus@Magnus:/var/run/mysqld$ /usr/bin/mysqld_safe --user=mysql & [1] 7234 bucephalus@Magnus:/var/run/mysqld$ nohup: ignoring input and redirecting stderr to stdout Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[7273]: started STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld_safe[7283]: ended First, I want to know where "--user=mysql" comes from? I didn't create that user. Second, before I got this response I got some errors about two files, /var/run/mysqld/mysqld.pid and /var/run/mysqld/mysqld.sock stating that these couldn't be deleted, so I removed them manually. Does anypone have any ideas why I can't start the server?
View Replies !
Scheduled Backups
I am not familiar with backing up mysql. I understand the mysqldump tool can be used with php somehow and also that there are several free tools available.
View Replies !
Creating Backups
I have designed a peice of code in 2 dif prog langs which create backups of the same database. However both take a fair old while to run because it goes through line by line of each table to create the backup. I have 2 servers: First is where all the live data sits and the second stores all my archived / backup data. Is there any way in SQL to actually copy from one server to another the complete database without human intervention. This probably is a really simple question but i haven't really looked down the path of using just SQL to do it?
View Replies !
Rolling Backups
I currently have windows task scheduler set up to run a batch file that runs mysqldump, to backup all of my local databases, it looks a bit like this: mysqldump --user=root --password=password --all-databases > "d:ackupsdump.sql" I want to modify so that the file name of the backup is based on todays date, and then get it to automatically delete the oldest backup file, so that I always have the last 5 days of backups.
View Replies !
Backups & Best Practices
I have just been told that I am responsible for Administering a MySQL install. I am an experienced SQL Server Admin and have an idea what needs to be set up, Backups for one thing). I plan to use the MySQL Administrator GUI. I'm looking for Best Practices in General and for backups in particular. The databases ar MyISAM. Any help would be appreciated. MySQL version is 4.1.15-nt client version is 5.0.11 Administrator version is 1.1.5
View Replies !
Automatic DB Backups
I've been looking at a way to backup my DB automatically (say, every day). All I found was this backup (http://members.lycos.co.uk/wipe_out/automysqlbackup/) but I have to idea how this works, especially these 2 lines - Make the file executable :- chmod u+rwx - Every day AutoMySQLBackup will run (if setup on /etc/cron.daily).
View Replies !
InnoDB Weekly Backups
We need to implement a backup solution for our innodb tables (~50gigs) that: 1) Runs automatically, weekly, and in the background w/o interrupting normal usage 2) Is capable of restoring individual tables 3) Can backup across networked computers I've searched and found a few options: InnoDB Hot Backup ($510/year), PeerSync ($899/perp), and Servosity Remote data backup (~$350/month). Does anyone have any experiences or suggestions about other solutions or the ones above?
View Replies !
Full Server Backups
Am i right in assuming that if I copy my C:/.../mysql/data direcotry and if my entire server crashed, I reinstall mysql. and drop the oringal /data direcotry into the new installtion /data direcotry, will everything work out ok? Anyone have any other methods of backing up an entire MySQL server? Is there a program that can make a query that will authomatically create the databases, and do it in one file?
View Replies !
MySQL Database Backups
I feel like such a dumb*** because I don't know how to make automatic database backups. I would love to make backups every 3 days or so. Perhaps 3 times a week would be good, not daily though. I'm using MySQL and Windows and my current method of database backing is to do it manually. I navigate to the mysql data directory, and copy and then paste it onto a CD of mine. I hate how I have to manually do this all the time. I tried Windows scheduled task manager to create a backup of the mysql data directory but its a no go. Somehow it always fails when trying to back it up
View Replies !
Scheduled Backups Not Happening
I am running 5.0.19 on a win2k server and for some reason the sheduled backups just dont seem to happen. If i try to manually initiate the job "execute backup now" it works fine but scheduling it doesnt seem to do anything?
View Replies !
Doing Internal Data Backups
We have managed server backups in case of server error. We also do four daily mySQL dumps using a Linux Script which simply dumps the mySQL database to a file whos name is the date and time. This was, if we ever accidentally delete data we can retrieve it. This is not in case of server error (as the backups are stored within the server itself anyway). These are data backups so that we have an ongoing backup of data in the mySQL. The trouble is that each backup is taking 150mb because file attachments are stored in the database. This seems silly as most of the data is in fact the same.
View Replies !
Importing Large Backups
I have a 600 MB .sql dump which I got from someone. I need to import that .sql file to my database. PHPmyadmin does not allow that big files to import. The desktop based mysql client (SQLYog) which I am using to manage MySQL databases, also crashes while importing. I am on a windows system. Could you please suggest me a better and effective way to import it?
View Replies !
Lost Phpmyadmin Password, Can't Do Backups!
I'm trying to run a backup on a bitrock install sugarcrm on linux. apache is running on port 8888, i try to get into phpmyadmin but it asks for user and password. I don't know what the user/password is. I saw user file so i know user = administrator. but I don't know password. I have access to the httpd.conf file. I see the last part of the file concerns authentication for phpmyadmin. Is there a way to turn off authentication? I just need to get a backup. I also try to use the command line but i get error 2202. it can't read the /tmp/mysql.sock file. i know mysql works because sugarcrm works fine from a browser.
View Replies !
Backups Of Raw Db Files - Indexes Needed?
Right now I am backing up mysql 4.0.14 on Windows 2000 with a scheduled batch file that shuts down the mysql service - copies the entire data directory to a backup directory, and restarts the mysql service. this ackup directory then goes onto tape a couple of hours later via veritas remote backup agent. I have tested a restore of this backup method and it works fine. Now I would like to add some more indexes to a table that has 11 million rows, however the index files will be very large. Is it necessary to backup index files? In case a restore was needed, I could just recreate the indexes manually (via a batch file with the correct index commands). Will mysql choke if the table definition shows an index - but the index file is missing? are there any "bad things" that will happen if index files are missing?
View Replies !
Creating Backups From Shell Scripts
I am thinking of using the shell script mentioned here to take daily backups. I have added the --opt option to the mysqldump command. Is it essential to have a separate user for the backup process? Binary logging is disabled. Any precautions that I need to take?
View Replies !
MySQL Admin Scheduled Backups
Two problems: 1.-- MySQL Administrator will do backups manually and for sometime it did scheduled backups, as well. Now a scheduled job will fail and generate an event id 1000 error: Faulting application MySQLAdministrator.exe, version 1.2.3.0, faulting module MySQLAdministrator.exe, version 1.2.3.0, fault address 0x001e5342. 2.-- The SQL error logs have disappeared since starting the use of Administrator for backups. Is there a way to get them back or at least start the recording again? The only thing that ever showed up in the logs was the shut down and start up of the MySQL service at the beginning and end of a flat file backup of the entire database. Still... it would nice to have the logs back.
View Replies !
MySQL Admin Backups Won't Work
I’m using MySQL Administrator and MySQL Query Browser and want to make a backup of a database. First you click on the “New Project” button and name the project. Next the documentation for MySQL Administrator says… “To choose the databases and tables that will be backed up, select the database from the schemata list and click the > button. Once the database is in the Backup Content list, you can un-check specific tables that you do not wish to back up. “ That sounds straight forward enough – it works like every other gui out there. The problem is you click on the database you want to backup and it doesn’t become highlighted and when you click on the”>” button, nothing happens. Why?
View Replies !
Backups Taken By Mysqldump Locks Database
i've made a backup / restore script which first dumps the content of the database with mysqldump and the copies the backup file to another location. What i find strange is that after mysqldump is finished with dumping the data and the copy operation is started, the database does not accept inserts or update. In our Java application (using hibernate) we are informed that tables are locked (even thoug they should not be). when the copy process is finished it works again!
View Replies !
MYSQL ADMINOSTRATOR And Scheduled Backups
anyone use the MYSQL ADMINISTRATOR programs (in win xp platform) and actually have the SCHEDULED backups to work? i can create a scheduled backup and hit the BACKUP NOW to do a manual one, but the auto scheduling one doesnt work. i installed their latest version and still nothing...
View Replies !
Incremental Backups Using Update Logs With Multiple Databases
I've set up my server to keep update logs for incremental backups, as described in Kevin Yank's book (Build Your Own... 3rd Edition), but I've noticed that the update.* files have entries from all the databases on my server. Is there a way to automatically split up the log files so that I can have separate update.* files for each database?
View Replies !
Auto-backup Database - Delete Backups Older Than X Days
I am not planning on doing this yet but I need to know from a feasibility point of view. I know it is possible to set up cron jobs to automatically backup databases on whatever time cycle you want but I have no experience writing them. Does anyone know how you tell it to backup your database with a name and a timestamp, while also deleting backups older than x (7 for example) days? Also does anyone know how to keep backups secure online? Do you encrypt them? Do you download them to a local server? To your own computer (unless its a very large database)? How do people practically go about making sure backups work, and secure them effectively. And if you do download them to your own local computer, how do you go about doing that? Is it an automatic thing? I just have all these questions but I have no idea about going about performing backups the most efficient and secure way!
View Replies !
Restoring A DB
I have MySQL 5x installed on Windows Server 2003 and I am trying to restore a database that was created in Linux on MySQL 4.1.25 using a database dump. When I open the MySQL command line, I log in as root by typing my password. I am given the mysql > prompt and I type: mysql -u root -p old_db < db_backup.sql; I get a syntax error. I have tried it with and without the password showing up after the -p. Ideas?
View Replies !
Restoring A MySQL Db
I have a new computer and need to restore a ibdata1 file - how do I do that? It is second time I have problems like this - and mysql just crashes, so I dont even know what it wrong.
View Replies !
Restoring Database!
I have 2 backup files (using mysqldump.) The first one is for the whole database, backed up from Januaray to July 25. The second one is just for 2 tables of that database, backed up from June 29 to July 29. These 2 tables are updated continuously, and from July 25 to July 29, there is no new record in the rest of the tables. The data in both files contains foreign characters, and are encoded by UTF-8 character set. The problem is that now I have to restore my database, back to July 29. But I just can read back only 1 file by using mysql command, because there are some records are duplicated (from June 29 to July 25). So I tried to find some feature like --ignore or --replace, and I found out that mysqlimport has both! But after testing to import data by mysqlimport, all records are set to NULL. I guess the problem is mysqlimport was not parsing foreign characters correctly. I also noticed that mysqlimport has a --default-character-set option, but unfortunately, the currently version of MySQL that I'm using (3.23.56) does not support Unicode... So is there anyone has any idea how to solve this issue?
View Replies !
Restoring From Mysqldump
How do I restore a single database (selectively) from a mysql dump of many databases. ie: I have a server with a few databases on it, I have run: mysqldump --all-databases > all_databases.sql Which has created a nice file ..... Now what do I do if I just want to restore just one of the databases I have just dumped into this file.
View Replies !
Restoring A DB After OS Crashed
I have a computer on my network that ran Windows XP Pro & MySQL 5.0 . The OS crashed and I cannot boot from it. However, I have access to the hard drive. I have a database on that server and have located the database (let's call it "my_db") name as a folder ("my_db") in the mysql "data" folder. How can I convert the folder ("my_db") with the .frm & .opt files to the SQL to move the database to another server?
View Replies !
Restoring MySQL Db
I have a mySQL dump of arounf 300MB that I need to restore. I am using the syntax: mysql -u DB_USER_NAME -p DB_NAME < BACKUP_FILE_NAME.sql It is prompting me for a password but rejects all known passwords. Is the password required the root mySQL password, the password attached to the database or another one?Is there any other way of successfully restoring this db?
View Replies !
Restoring Part
I've got a backup of all the databases on my server, which includes databases from a number of different users. How do I restore the backup for only one specific user (ie only restore his databases from the backup file)
View Replies !
Restoring A Backup
i have an application running on it. Several days ago the server has crashed. And i had an backup of 2 months old. After the restore the application is working again. But my provider has a newer backup of 2 days before the crash. So he have send me this backup. It contains 3 file's. *.frm, *.myd and *.myi. How can i get these file's in to my database.
View Replies !
Restoring Tar.gz Backup
I backed up my subdreamer & vbulletin database. They were in tar.gz. Now i cannot restore any of these backups in cPanel nor phpmyadmin. I do know that it usually is in a .sql, .zip, .gz but when i open the tar.gz file i see these MYD and frm etc files. None of them are in sql and when i try to upload the tar.gz file it gives me this sort of error: [first 6 lines] ----BEGIN CUT---- eNrtfQ10XMV59tz936s9smQbMCDgcnBimSzy/q8kH45lbBkBNgjbYAMBfLV7pb1o/9i9a0mEJAqh YAhtTEvP8Wn5UueEr3UITd2WJm5LHKdxWqclrdPQxs3nJE7Cl7gNbZ2UJP4al/3ed2buz64kSwJb ATOv/Wjmzp2fd96Zeefn3ndv/+bNt23uVdZFlXUxZWP/rb1KTIkr0Wi6J52St2yFW0SW1925pVdZ flO2V6k+mC+rlapW6crrQ13lXDm8U4l1JSNdsa6oEotEUqsi3auiKSWa7k1EeyPdSl4r9Cj942Vl ubxpYsvtG3uVRFe0Kxa9rmqoxaxaycp3bNms3LYlrKy9sf/WrWHlzn4oc5teVG7qV1JdEXlw01rg [end first 6 lines] and i don't feel like uploading (don't know if it's even possible) the 141 myi and MYD etc files seperately. Does anyone know how to restore my backup?
View Replies !
Restoring From A Backup
I used MySQL Admin to backup a database, then dropped the database and used the Admin again to restore as a test. The database had some tables that contained encrypted data that was encrypted with AES_ENCRYPT. When I restored the database, I was unable to access the encrypted data with AES_DECRYPT. Is there something I'm doing wrong, or maybe a way around this?
View Replies !
RESTORING MY DATABASE
Hi, Im a newbie here and in MY SQL... I JuST WANT TO ASK a question about MY SQL 2000 SERVER In my wINDOWS2000 server I setup an Online game named.. MU ONLINE and use my computer as a server computer.... all the data is in the database MU ONLINE and RANKING...it works fine for a couple of months and then I decided to upgrade my server... I downloaded all the updates for my Online game, I also restore the database to another folder since it is a new update.. So from DB folder to DB1 folder... then I deleted DB folder the old database back up... Then when I try to play the game...There's no mobs or etc... so it means no database is running... so I downgraded again my server but when I did that... when I try to restore database...it says.
View Replies !
Restoring Backup
My host screwd up and deleted my My_SQL files. fortunately I had just made a back up. I have since then switched hosts and need to get my database back up, but whenever I try uploading it with php my admin I get a timeout problem. I need to get the database up within 2 days but can't figure out any way to do it.
View Replies !
|
TRACKER
