When I fired up HeidiSQL, the tables looked like they were there, but the databases were showing as zero bytes.<\/p>\n\n\n\n
![\"HeidiSQL](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-09-600x142.png\")
<\/figure><\/div>\n\n\n\nNavigating to any of the tables brought up \"This view probably contains an error in its code. SQL Error (1932): Table 'xyz.wp_posts' doesn't exist in engine.\"<\/p>\n\n\n\n
![\"Error](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-10.png\")
<\/figure><\/div>\n\n\n\nThankfully, the solution is pretty simple, even though it took me a few hours to figure it out.<\/p>\n\n\n\n
How to move MariaDB database files after upgrading version on Windows<\/h2>\n\n\n\n- Open command prompt<\/a> as administrator<\/li>
- Stop MariaDB<\/a> with \"net stop mariadb\"<\/li>
- Copy the databases<\/a> from the old \/data to the new \/data<\/li>
- Replace ibdata1<\/em><\/a> in the new \/data with the one in the old \/data<\/li>
- Restart MariaDB<\/a> with \"net start mariadb\"<\/li><\/ol>\n\n\n\n
Yeah, it's that simple.<\/p>\n\n\n\n
This assumes you have already installed MariaDB and the new version is working properly.<\/p>\n\n\n\n
Let's go through the steps below.<\/p>\n\n\n\n
Open Command Prompt as Administrator<\/h2>\n\n\n\n
To start and stop MariaDB, you need to run Command Prompt as an administrator. You'll get an access denied error message if you try to do it with the regular command prompt.<\/p>\n\n\n\n
In the search bar, type \"cmd\".<\/p>\n\n\n\n
You should see the Command Prompt app listed. Click \"Run as administrator\".<\/p>\n\n\n\n
![\"Directions](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-01-600x457.png\")
<\/figure><\/div>\n\n\n\nYou should see an administrator command prompt. You'll know it's correct because the title bar will say \"Administrator: Command Prompt\" rather than \"Command Prompt\".<\/p>\n\n\n\n
If you can't open Command Prompt as an administrator, you may not have sufficient permissions on the account you're using. In that case, you'll need to log in with a different account, or perhaps you have an IT manager who's locked you out.<\/p>\n\n\n\n
Stop MariaDB<\/h2>\n\n\n\n
Type \"net stop mariadb\" (without the quotation marks) and hit Enter.<\/p>\n\n\n\n
It may take a few seconds, but it should say \"The MariaDB service was stopped successfully\". That's when you know you're ready to proceed to the next step.<\/p>\n\n\n\n
![\"administrator](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-02.png\")
<\/figure><\/div>\n\n\n\nIf you get the message \"The MariaDB service is not started\", that's ok, you can proceed to the next step. You just need it to not be running or it won't let you replace the ibdata1<\/em> file.<\/p>\n\n\n\nIf you try to stop MariaDB with the regular Command Prompt, you'll get the error message \"System error 5 has occurred. Access is denied.\" Just go to the previous step and open Command Prompt<\/a> as an administrator.<\/p>\n\n\n\n![\"non-administrator](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-12.png\")
<\/figure><\/div>\n\n\n\nCopy the databases<\/h2>\n\n\n\n
The database files will be in \/MariaDB 10.1\/data<\/em>\/, where \"10.1\" is the old version you had running.<\/p>\n\n\n\nMy files were installed in C:\/Program Files\/MariaDB 10.1\/data<\/em>\/, but you may have installed MariaDB somewhere else.<\/p>\n\n\n\nEach folder in \/data\/<\/em> is a unique database from your previous installation.<\/p>\n\n\n\nJust copy the folders you want to keep from the old folder to the new folder. If you're anything like me, there are a few in there that you don't need any more. This works fine with just copying over the ones you need. However if you want to copy them all over and delete the un-needed ones in HeidiSQL, that's probably even better.<\/p>\n\n\n\n
Replace ibdata1<\/h2>\n\n\n\n
The step I was missing that caused the databases to show empty, broken tables was to copy ibdata1<\/em> from the old \/data<\/em> folder to the new \/data<\/em> folder.<\/p>\n\n\n\nOpen the old folder, copy ibdata1<\/em>.<\/p>\n\n\n\n![\"arrow](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-04-600x70.png\")
<\/figure><\/div>\n\n\n\nPaste it in the new folder.<\/p>\n\n\n\n
![\"arrow](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-03-600x108.png\")
<\/figure><\/div>\n\n\n\nYou'll get a message that \"The destination already has a file named 'ibdata1'\".<\/p>\n\n\n\n
Select \"Replace the file in the destination\".<\/p>\n\n\n\n
![\"Prompt](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-06.png\")
<\/figure><\/div>\n\n\n\nThat should be all you need to do. However, if you haven't stopped MariaDB, you'll get a message \"The action can't be completed because the folder or a file in it is open in another program\".<\/p>\n\n\n\n
Just open a command prompt as an administrator<\/a> and stop MariaDB<\/a> using the steps above.<\/p>\n\n\n\nThen just hit \"Try Again\" and it should copy correctly.<\/p>\n\n\n\n
![\"Error](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-07.png\")
<\/figure><\/div>\n\n\n\nStart MariaDB<\/h2>\n\n\n\n
To actually use the databases, you'll need to restart MariaDB.<\/p>\n\n\n\n
Go back to the Administrator Command Prompt, or open a new one<\/a>.<\/p>\n\n\n\nType \"net start mariadb\" without the quotation marks.<\/p>\n\n\n\n
It will take a few seconds, but you should see \"The MariaDB service was started successfully.\"<\/p>\n\n\n\n
Yeah, it's that simple.<\/p>\n\n\n\n
This assumes you have already installed MariaDB and the new version is working properly.<\/p>\n\n\n\n
Let's go through the steps below.<\/p>\n\n\n\n
Open Command Prompt as Administrator<\/h2>\n\n\n\n
To start and stop MariaDB, you need to run Command Prompt as an administrator. You'll get an access denied error message if you try to do it with the regular command prompt.<\/p>\n\n\n\n
In the search bar, type \"cmd\".<\/p>\n\n\n\n
You should see the Command Prompt app listed. Click \"Run as administrator\".<\/p>\n\n\n\n
<\/figure><\/div>\n\n\n\nYou should see an administrator command prompt. You'll know it's correct because the title bar will say \"Administrator: Command Prompt\" rather than \"Command Prompt\".<\/p>\n\n\n\n
If you can't open Command Prompt as an administrator, you may not have sufficient permissions on the account you're using. In that case, you'll need to log in with a different account, or perhaps you have an IT manager who's locked you out.<\/p>\n\n\n\n
Stop MariaDB<\/h2>\n\n\n\n
Type \"net stop mariadb\" (without the quotation marks) and hit Enter.<\/p>\n\n\n\n
It may take a few seconds, but it should say \"The MariaDB service was stopped successfully\". That's when you know you're ready to proceed to the next step.<\/p>\n\n\n\n
<\/figure><\/div>\n\n\n\nIf you get the message \"The MariaDB service is not started\", that's ok, you can proceed to the next step. You just need it to not be running or it won't let you replace the ibdata1<\/em> file.<\/p>\n\n\n\n If you try to stop MariaDB with the regular Command Prompt, you'll get the error message \"System error 5 has occurred. Access is denied.\" Just go to the previous step and open Command Prompt<\/a> as an administrator.<\/p>\n\n\n\n The database files will be in \/MariaDB 10.1\/data<\/em>\/, where \"10.1\" is the old version you had running.<\/p>\n\n\n\n My files were installed in C:\/Program Files\/MariaDB 10.1\/data<\/em>\/, but you may have installed MariaDB somewhere else.<\/p>\n\n\n\n Each folder in \/data\/<\/em> is a unique database from your previous installation.<\/p>\n\n\n\n Just copy the folders you want to keep from the old folder to the new folder. If you're anything like me, there are a few in there that you don't need any more. This works fine with just copying over the ones you need. However if you want to copy them all over and delete the un-needed ones in HeidiSQL, that's probably even better.<\/p>\n\n\n\n The step I was missing that caused the databases to show empty, broken tables was to copy ibdata1<\/em> from the old \/data<\/em> folder to the new \/data<\/em> folder.<\/p>\n\n\n\n Open the old folder, copy ibdata1<\/em>.<\/p>\n\n\n\n Paste it in the new folder.<\/p>\n\n\n\n You'll get a message that \"The destination already has a file named 'ibdata1'\".<\/p>\n\n\n\n Select \"Replace the file in the destination\".<\/p>\n\n\n\n That should be all you need to do. However, if you haven't stopped MariaDB, you'll get a message \"The action can't be completed because the folder or a file in it is open in another program\".<\/p>\n\n\n\n Just open a command prompt as an administrator<\/a> and stop MariaDB<\/a> using the steps above.<\/p>\n\n\n\n Then just hit \"Try Again\" and it should copy correctly.<\/p>\n\n\n\n To actually use the databases, you'll need to restart MariaDB.<\/p>\n\n\n\n Go back to the Administrator Command Prompt, or open a new one<\/a>.<\/p>\n\n\n\n Type \"net start mariadb\" without the quotation marks.<\/p>\n\n\n\n It will take a few seconds, but you should see \"The MariaDB service was started successfully.\"<\/p>\n\n\n\n<\/figure><\/div>\n\n\n\nCopy the databases<\/h2>\n\n\n\n
Replace ibdata1<\/h2>\n\n\n\n
<\/figure><\/div>\n\n\n\n<\/figure><\/div>\n\n\n\n<\/figure><\/div>\n\n\n\n<\/figure><\/div>\n\n\n\nStart MariaDB<\/h2>\n\n\n\n
![\"Administrator](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-05.png\")
<\/figure><\/div>\n\n\n\n![\"HeidiSQL](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-11-600x159.png\")
<\/figure><\/div>\n\n\n\n![\"Error](\"https:\/\/intelliwolf.com\/wp-content\/uploads\/2021\/12\/2021-12-14-move-mariadb-files-08.png\")
<\/figure><\/div>\n\n\n\n