![]() You can connect to the database from the same computer where it is installed with the mysql client tool. The output of the command indicates which database server (MySQL or MariaDB) is used by the installation, and will allow you to identify which guides to follow in our documentation for common database-related operations. To identify which database server is used in your stack, run the command below: $ test -d /opt/bitnami/mariadb & echo "MariaDB" || echo "MySQL" On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB. ![]() Also you can Buy me Coffee(read support me) to keep up the good work.NOTE: We are in the process of modifying the configuration for many Bitnami stacks. If this post helped you show some love with claps and comments. If you still have issues then please leave a comment and I will do my best to get back to you. Some amazing people shared their problems and solutions there. If you do face any problem take a look at the comment section. If you have followed my instructions then you should have a functioning XAMPP with no issues. If everything is working fine than you can delete the xampp-old file.Go ahead and check whether your site and databases are working properly or not.After that run the following command mysql_upgrade in the Shell option.If you have followed all the steps correctly you will get a success message “ Import has been successfully finished”.Based on how many databases you have it will take some time.Import ‘ all-db-dump.sql’ file through the import option directly to server.Now restart both Apache and MySQL server.Change the value 600 to a higher value may be 6000.Make them high enough so big files can work on the server. post_max_size and memory_limit need to be larger than upload_max_filesize.Now configure the php.ini file and increase the value for the following options upload_max_filesize, memory_limit, post_max_size.It helps especially with very big databases. You can use CLI for importing database.Now Copy the htdocs folder from ‘ xampp-old’ folder to ‘ xampp’ folder.Start both Apachee and MySQL server and check whether they are working properly or not, also check PhpMyAdmin page.Now go to xampp folder and run the xampp control panel as Administrator.Install it in the same drive where your old Xampp originally was.This way if anything goes wrong you will be able to get back to the old version very easily. Now rename your ‘xampp’ folder to ‘xampp-old’.Now stop both Apachee and MySQL servers and quit the xampp control panel.This will create a SQL file named “ all-db-dump.sql” that contains all the databases in MySQL server.If you don’t have any password just press enter. If you have different user for databases then change the value ‘ root’ with username. ![]()
0 Comments
Leave a Reply. |