RESTORE MYSQL DATABASE FILES FROM ONE SERVER TO ANOTHER


You should be able to restore by copying them in your database folder.
You should copy ibdata files too.

You should do it while the server is not running.

MySQL data files is in /var/lib/mysql/

Terminal command:

     sudo service mysql stop

     sudo cp -Rp /old/databasefolder/databasename  /var/lib/mysql/

     sudo service mysql start

Comments

Post a Comment

Popular posts from this blog

CakeAdminLTE is based on AdminLTE Theme for CakePHP 2.4+

Image
CakeAdminLTE v.1.0 CakeAdminLTE is based on  Twitter Bootstrap 3.0+  and  AdminLTE Theme  for  CakePHP 2.4+ AdminLTE Dashboard and Control Panel Template  Responsive admin template  Free & open source  Built with Bootstrap 3  Easy to customize Quick Start Download the .zip file Extract the files into your CakePHP folder To enable your theme add the following to your "app/Controller/AppController.php" class: public $theme = " CakeAdminLTE " ; IMPORTANT:  If you would like to bake your app, please make sure you have enabled the theme before baking. DOWNLOAD:   CakeAdminLTE
Read more

The Rise of Tauri and Lightweight Desktop Apps

Image
  In recent years, there’s been a growing interest in lightweight desktop applications, particularly among developers looking to build fast, efficient, and secure software with minimal resource overhead. This shift is reshaping the software development landscape, with frameworks like Tauri leading the charge. Let’s explore why lightweight desktop apps are gaining traction and how Tauri is emerging as a top choice for developers. Why Lightweight Desktop Apps Are on the Rise Resource Efficiency : Traditional desktop apps, especially those built with Electron or similar frameworks, can be heavy on memory and CPU usage. Lightweight apps address this by reducing resource consumption, leading to faster load times and smoother performance, even on older or less powerful machines. Cross-Platform Development : Developers are looking for ways to write code once and deploy it across platforms (Windows, macOS, Linux). Lightweight frameworks like Tauri allow for cross-platform development witho...
Read more

Hostinger | Free Web Hosting with PHP and MySQL, Website Builder, No Ads

Image
New generation of free hosting Forget stereotypes about free web hosting. Hostinger is different. We provide reliable and feature rich hosting with fanatic user support! Our service uptime is 99.9% - thanks to cloud computing technology we utilize. PHP and MySQL Support We support PHP and MySQL without any restrictions. Our PHP engine comes with all features and functions enabled. You can switch to any PHP version in one click and manage databases with phpMyAdmin tool.   No ads or banners on your pages No text links. No annoying pop-ups. No annoying banners. No mandated forum posting. Your web site will be 100 percent ad free forever.   Software auto installer Just with a few clicks you may install Wordpress, Joomla, PrestaShop, phpBB, Drupal and may other scripts. Fully functional and professional looking web site can be setup in minutes.   Easy to use website builder You can now build your site very easy. ...
Read more