Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home MySQL Where MySQL Data Dir And Innodb Data Home Dir Location

Where MySQL Data Dir And Innodb Data Home Dir Location

I’m going to move my current MySQL server to another server so I have to backup all my current databases. One important step I need to do is check to see how data files for both MyISAM and InnoDB Storage Engines are stored by taking a look at the datadir and innodb data home dir

Below are methods to find where are data folder:

1. PhpMyAdmin – Variables tab

It’s easiest way and you may find some useful information there. Simply login to the PhpMyAdmin with root account. At the landing page, click on the Variables tab.

PhpMyAdmin Mysql Variables

PhpMyAdmin Mysql Variables

Then search for keyword “datadir” and “innodb data home dir”.

PhpMyAdmin MySQL datadir

PhpMyAdmin MySQL datadir

PhpMyAdmin MySQL innodb data home dir

PhpMyAdmin MySQL innodb data home dir

2. MySQL configuration file (my.ini or my.cnf)

Or you can find and open the my.ini file (on Windows) or my.cnf file (on Linux) then search for keyword “datadir” and “innodb_data_home_dir”

[text] #Path to the database root
datadir="D:/MySQLData/"
[/text] [text] #*** INNODB Specific options ***
innodb_data_home_dir="C:/MySQL Datafiles/"
[/text]
Jul 3, 2011Hoan Huynh
WOEID Of Eight Capital Cities In AustraliaCheck Up Time In Windows Server 2008 - 7 - Vista - XP
You Might Also Like:
  • Tips For Tuning And Optimizing Mysql On Low Memory Dedicated Server Or VPS
  • MySQL Incorrect Data Type Value In Column
  • Change or reset MySQL Root Account Password
  • How To Tune And Optimize MySQL Performance With MySQLTuner
  • Linux Find Out PHP/ MySQL/ MySQLD/ HTTPD … Command File Location
  • Schedule Backup And Zip MySQL Database In Windows
  • PHP Connect To MySQL Read Data And Export XML Format
  • Free Mysql Profiler similar to Microsoft SQL Server Profiler – LogMonitor
  • Install LAMP (Apache, MySQL and PHP in Linux) on CentOS
  • MSSQL Export A Table Data To CSV
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

11 years ago MySQLInnoDB, MyISAM, phpMyAdmin, Storage Engines704
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
24,455 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
21,836 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
17,652 views
JQuery Allow only numeric characters or only alphabet characters in textbox
14,986 views
C# Read Json From URL And Parse/Deserialize Json
11,719 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Things to Learn about Installingderm Loan Type S
  • Online Photo Editor – Free Photoediting Software
  • A Guide to Finding the Best Paper Sellers
  • Photoediting in Home Isn’t Hard to Do!

  • Free Photo Editor Online
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (647)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development