Résultats de recherche
[SOLVED] mysql database location? - Ubuntu Forums
https://ubuntuforums.org/showthread.php?t=1663924Traduire cette page
10 janv. 2011 - where are the databases located? how to open up the lan to database queries? I tried to login from an XP machine to my ubuntu mysql server and cant. When I explore the network from XP, it shows my ubuntu desktop as part of the workgroup.3 nov. 2014
How To Move a MySQL Data Directory to a New Location on Ubuntu ...
https://www.digitalocean.com/.../how-to-move-a-mysql-data-direct...Traduire cette page
21 juil. 2016 - Whether you're adding more space for data or evaluating ways to optimize database performance, this tutorial will guide you through relocating MySQL's data directory.How to Change a MySQL Data Directory to a New Location Using a ...
https://www.digitalocean.com/.../how-to-change-a-mysql-data-dire...Traduire cette page
2 déc. 2016 - The directions here are suitable for servers that run a single instance of MySQL. If you have multiple instances, the guide How To Move a MySQL Data Directory to a New Location on Ubuntu 16.04 can help you with directions for explicitly changing the location through configuration settings.Location of mysql database files in Ubuntu | Freedom To Learn ..........
https://gaurishpatil.wordpress.com/.../location-of-mysql-database-fi...Traduire cette page
4 mai 2009 - Location of mysql database files in Ubuntu: Taking backup in phpmyadmin is very easy... but when I want see where these tables stores that very interesting for me , after googling finaly got postion of database in Ubuntu... as... /var/lib/mysql Also if we use wamp then.. C:\wamp\bin\mysql\mysql5.1.33\data ..How do I move the MySQL data directory? - Ask Ubuntu
https://askubuntu.com/.../how-do-i-move-the-mysql-data-directoryTraduire cette page
15 mai 2012 - I found that AppArmor was the culprit by examining the syslog , and was able to successfully change the mysql data location by following this process. Please note that, in files edited below, lines starting with + were added, and lines starting with - were removed. You should not actually type/paste the + ...where is my database saved when I create it in MySQL? - Stack Overflow
https://stackoverflow.com/.../where-is-my-database-saved-when-i-c...Traduire cette page
19 juil. 2011 - In your mysql configuration file (usually /etc/mysql/my.cnf) you should have a datadir property, which is the location where mysql will save its data. Something like: datadir = /var/lib/mysql. It then creates a subdirectory inside that for each database where it will store the database content (ex: ...mysql - Where do I find .SQL files on Ubuntu Server? - Server Fault
https://serverfault.com/.../where-do-i-find-sql-files-on-ubuntu-serv...Traduire cette page
17 déc. 2011 - By default MySQL stores its files in /var/lib/mysql but if the default location has been changed then a more reliable way to find out where the files are kept is to check the config file: grep datadir /etc/mysql/my.cnf. Note that the database files do not end in .SQL. In part it depends on what kind of engine ...How to change the MySQL data default directory | Ubuntu Geek
www.ubuntugeek.com/how-to-change-the-mysql-data-default-dire...Traduire cette page
23 janv. 2009 - Mysql data directory is important part where all the mysql databases storage location.By default MySQL data default directory located in /var/lib/mysql.If you are running out of space in /var partition you need to move this to some other location. Note:- This is only for advanced users and before moving default ...How to move MySQL data directory in Ubuntu Server | Mikael Ståldal's ...
https://www.staldal.nu/.../how-to-move-mysql-data-directory-in-ub...Traduire cette page
9 déc. 2011 - By default, the MySQL data is placed in /var/lib/mysql , which is a reasonable default. However, sometimes you want to place it somewhere else, such as on an other file system. Using a symlink doesn't seem to work, so you have follow this procedure. To move the MySQL data directory from /var/lib to ...Moving the MySQL data directory Ubuntu 16.04 - Database ...
https://dba.stackexchange.com/.../moving-the-mysql-data-director...Traduire cette page
1 sept. 2016 - Verify the existing MySQL installtion: mysql -u root -p. From the MySQL prompt, do: select @@datadir;. You should see the current data directory: /var/lib/mysql/. Exit the MySQL mode: exit. Stop MySQL: sudo systemctl stop mysql. Verify that MySQL is stopped: sudo systemctl status mysql. Copy the data to ...