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

How to restore MySQL database from WAMP?

Tags:

database

mysql

wamp

Last month I had to reinstall Windows and I've moved the WAMP folder to another partition. Now I've installed WAMP again but I need the old database. How can I take the old MySQL database from the saved WAMP folder on the safe partion?

In the wamp/bin/mysql/../data/ I have my old databases. If I copy the database folder only, in phpMyAdmin I can't see all the tables/views from the old database.

like image 583
dole doug Avatar asked Jan 17 '10 20:01

dole doug

People also ask

How do I restore an existing MySQL database?

In Database Explorer, right-click the server connection on which you want to restore the database and select Backup and Restore > Restore Database. In the Database Restore Wizard, select the backup file and click Restore.

Does Wamp support MySQL?

WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database.

1 Answers

Looks like you use InnoDB tables, so you should also copy ib* files in data folder (but this will overwrite any InnoDB table created in new installation.)

Alternatively (even better) you may set 'datadir' parameter in configuration file and specify path to data folder in old installation.

like image 71
noonex Avatar answered Sep 24 '22 12:09

noonex
Sign in to Comment

Related questions

MySQL 8 won't start after "Data dictionary upgrading" in log file
Access with 1 MySQL Table asking for credentials
innodb_ft_min_token_size = 1 performance implications
Could not increase number of max_open_files to more than 4096 (request: 4214)
mysql-docker-container - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Include additional columns in Where clause of Hibernate/JPA Generated UPDATE Query
How should I audit changes in a MySQL table (using MySQL 4)?
What's the best way to implement a counter field in MySQL
Calling remote php functions from an iPhone app
Is it true I can't edit a MySQL trigger, I have to drop it and create a new one?
Can MySQL Cluster handle a terabyte database
mysql: How to free space (innodb)
Optimize MySQL query to avoid "Using where; Using temporary; Using filesort"
SQL Alternative to performing an INNER JOIN on a single table
Uploading to a Remote Server
MySQL cuts off string at special chars
MySQL Math and COUNT(*) in LIMIT
How to decode a string that has been UTF-8 encoded twice to simple UTF-8?
(Bitwise) Supersets and Subsets in MySQL
Mysql field name within regular expression

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!