where does MySQL store database files?

by

In any case you can know it: 

mysql> select @@datadir;
+----------------------------------------------------------------+
| @@datadir                                                      |
+----------------------------------------------------------------+
| D:\Documents and Settings\b394382\My Documents\MySQL_5_1\data\ |
+----------------------------------------------------------------+
1 row in set (0.00 sec)

Thanks Barry Galbraith from the MySql Forum http://forums.mysql.com/read.php?10,379153,379167#msg-379167

More Related Contents:

  1. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  2. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  3. If two columns are 1 then make new column
  4. MySQL: How to reset or change the MySQL root password?
  5. MySQL Server has gone away when importing large sql file
  6. #1071 – Specified key was too long; max key length is 1000 bytes
  7. MySQL : isn’t in GROUP BY
  8. MySQL: Can’t create table (errno: 150)
  9. What is maximum query size for mysql?
  10. Why is the estimated rows count very different in phpmyadmin results?
  11. Setting up foreign keys in phpMyAdmin?
  12. How to access remote server with local phpMyAdmin client?
  13. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  14. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  15. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  16. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  17. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  18. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  19. How to Import Multiple csv files into a MySQL Database
  20. Composite key as foreign key (sql)
  21. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  22. how to delete duplicate rows from a table in mysql
  23. SQL: deleting tables with prefix
  24. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  25. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  26. How do I write an SP in phpMyAdmin (MySQL)?
  27. How to import large sql file in phpmyadmin
  28. Import CSV to Update rows in table
  29. UTF8 problem with MySQL 5
  30. mySQL query to search all tables within a database for a string?

Leave a Comment