Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to migrate from mysql 5.1 to 5.5?

Tags:

mysql

migration

I am just migrating from 5.1 to 5.5. I copy my data from mysql5.1 data forlder to mysql5.5/data.

I just wondered if I can overwrite the file ibdata1 in mysql 5.5 data directory?

Thanks Arman.

EDIT

Yes I can copy 5.1 to 5.5 and then I need to run mysql_upgrade

like image 747
Arman Avatar asked Dec 21 '10 15:12

Arman

People also ask

How do I transfer data from one MySQL database to another?

To copy a MySQL database from a server to another, you use the following steps: Export the database on the source server to a SQL dump file. Copy the SQL dump file to the destination server. Import the SQL dump file to the destination server.

What does MySQL_ upgrade do?

mysql_upgrade saves the MySQL version number in a file named mysql_upgrade_info in the data directory. This is used to quickly check whether all tables have been checked for this release so that table-checking can be skipped. To ignore this file and perform the check regardless, use the --force option.

1 Answers

Have you visited the MySQL 5.5 FAQ: Migration portion of the reference manual? They have a specific page dedicated to moving from 5.1 to 5.5 with step-by-step guide (including making a backup).

like image 157
Brad Christie Avatar answered Oct 30 '22 08:10

Brad Christie
Sign in to Comment

Related questions

SQL Recursive Tables
How do I maintain PHP sessions across multiple domains on the same server?
How to model a Bayesian network or, more generally, a directed weighted graph, in SQL?
Sql date select rows within X seconds range of each other
iconv gives "Illegal Character" with smart quotes -- how to get rid of them?
For innodb table in MySQL, which is faster: varchar(255) or tinytext?
Using SUM so that NULL in columns make sum NULL
Java Exception Error - Sqlite preparedStatement.setBlob
MySQL Fulltext Stopwords Rationale
Any way to view ALTER TABLE after its been executed? -MySQL
In MATLAB can I convert a java boolean to a MATLAB logical?
SQL Replace Into question
Generate unique random alphanumeric characters that are 7 characters long
Does a transaction stop all race condition problems in MySQL?
binary log files analysis
Special character in database.yml for password
Naming conventions - Working with PHP and MySQL
Getting a precise execution time of a MySQL statement
What if a trigger fails?
mySQL: is it possible to make this query any faster?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!