eV/6CwMRUғTPxG\qN;Om3&h.3Cދ?7*7E̦Υ%쥱# T" 6ı}%ndm}7!|pwcP,) 3c[Av>mwOnL71B̡U-fiþB" NgN8 7BK vbv>2D:_6 !nMI+]þ$#}b^P ,Q)w6 e;e%}[s#t緕*C@{>|X-V!&Y}Khnx?!{`n٫´Oj/n8lfyk:u8LWgVˆ,X`k"rThT?' ?;#Ilw!_ ` mKpy%5R'wr2 mmV5L4SlC! !l^/KP>Ӹ %בC)\sslˎ5c=Jf:4?.nކ65)uhurWz |B2GtXh0+-xVr%MY_Ȃ#]@*%C=\ ' $ܿ, DzXڊ'qZmT DLM1Egl;t*r}݁Tٜ8E֥kO˳xA71:IbV D#'rL\ՋnyGW~c2P\FTU𰫚ƢBs/X- <40}UCdB=ű$c)w i16yiuYk[N%񘋤:/#6$}q[uKaFy&EvTe9XbJ&XM xWp~tpݷ loSB5U3W+l6]ywD~%^ g)}^ݠTځֳ2=-ia`s&͡+,0g=+p7M"jn*(XQ ?6R)gn:xF9ꌭNB;>ǦnX/`oJn)\9+'Wld}řY7z&ˇp5B4IBUV ፯@+*y8(%WS`nґ!WPBlӃsմB[R䘼 &LJ[9 2JCӿE3 Hu\L1$wh'e&M58o`X=sק#ݯ~2BjI\9R:eQK>Y.Y>p4Om<C3Gd`k)cۨPՂZ:P6]q=ꌕH.\w5s/ġ3]b<"БмuBep\:Yƃ5#OWHpNy awl:Xv #B̈#+yr2(r;v*^F(!Niԕ.QX9ĈW!x~d墮i~aϵ%SdkWJRI~}۝KԆ1Pw;ЃD 43V&,{] A(kT,"\؂uj>u9˟en81A ^)L6f/q=3M'nv#ey HcܢU|S@l†gU 4Vpj9:S)[} r&~7v pf[ @[9dҙRx ̘!VK+AsWr%4sr`Gԍ] j J/_|y.)9+, jYFG?$Sd\<}Z1ɧCV1}U`i7`P&{l6қBhBj6_| $f cc!H\];0kҀx9W}K)WV Gj&@{0G=Q;zB/G*֏; 8F>fƳwP}$_W<{e)PGFrbTEbZ&^Bh)-0ASR2lPf=V3_,뽣;Ym{?lmS KRTO0-YCZP[ @:D-jy .Kؔ? kp124@c52&Ax]"l~P_ƯҌ>QB`1J`S^l3cfB 巢6_a::B{$~q41A }f{vq>ct8Bb[lm[9P)ݠHtÉG d2 J}_&SԌ`<>`3jd~:HKԮFxvL7&t 夙se{PZlGv`}xt!aL9QRgU-%{l| s՟e>hBk%O3ZՀPaxIVoAF jY]>r37Prg"$t?X|t?':<hj-o0_"[B>[tlvږեvy18I5-mD1%m`1k\uԒȱQwn3׆Nh,._ڃPHo[/5Qd!cLUY{x^Ky$JKB

XAMPP includes phpMyAdmin, an open-source, browser-based tool for managing MySQL/MariaDB database servers. To backup a MySQL/MariaDB database using phpMyAdmin, follow these steps:

  1. Browse to http://localhost/phpMyAdmin or http://127.0.0.1/phpMyAdmin. If required, log in using your database access credentials. On a fresh XAMPP installation without any changes, you can log in as root with a blank password.

  2. Select the database to be backed up from the list in the left navigation pane. In this case, we’re backing up the WordPress database, which is named bitnami_wordpress.

    image1

  3. Select the "Export" command in the top navigation bar.

  4. On the resulting page, select "Quick" as the export method and "SQL" as the output format. Click "Go" to proceed.

    image2

phpMyAdmin will export the database to a text file as a series of SQL statements. Once done, the browser will prompt you to download it to the desktop. This text file is your backup, so store it safely!

image3

At a later point, you may wish to restore the database. To restore the data to a fresh MySQL/MariaDB database using phpMyAdmin, follow these steps:

  1. Browse to http://localhost/phpMyAdmin or http://127.0.0.1/phpMyAdmin. If required, log in using your database access credentials.

  2. Select the "New" command in the left navigation pane.

    image4

  3. On the resulting page, enter a name for the new database (in this case, myblog). Select the collation "utf8_general_ci". Click "Create" to create the database.

    image5

    Once the database has been created, it will appear in the left navigation pane.

    image6

  4. Select the new database from the left navigation pane. In the resulting page, select the "Import" command in the top navigation bar.

  5. Click the "Browse…​" button and select the backup file created earlier. Click "Go" to proceed.

    image7

    phpMyAdmin will import the data from the backup file. Once complete, you will see a screen indicating the status of the import.

    image8

If you browse the contents of the database, you should now see your original data.

image9

You should now update your application’s configuration and point it to your newly-created database. For example, with the Bitnami WordPress module, you will need to edit the wp-config.php file in the apps\wordpress\htdocs\ subdirectory of your XAMPP installation directory. Within this file, you will need to update the DB_NAME constant to use the new database name.

image10
By default, PHP (and therefore phpMyAdmin) is configured to only accept uploads up to 2 MB in size. If your database is larger than this, you need to modify the PHP configuration file to accept a larger upload size. To do this, edit the php.ini file in the php\ subdirectory of your XAMPP installation directory and increase the values of the post_max_size and upload_max_filesize variables. Save your changes and restart Apache for the changes to take effect.

Using Command-Line Tools

MySQL and MariaDB include two command-line tools that you can use to quickly backup and restore databases. The mysqldump tool is used to export the contents of a database to a text file, while the mysql client can be used to import data from a text file into a MySQL/MariaDB database.

To backup a MySQL/MariaDB database from the command line, follow these steps:

  1. Launch a new Windows command shell using the "Shell" button in the XAMPP control panel.

  2. Use the command below to export the contents of the selected database. In this example, we’re backing up the WordPress database, which is named bitnami_wordpress, to a file named bitnami_wordpress.sql. This text file is your backup, so store it safely!

    mysqldump --user=root --password="" bitnami_wordpress > bitnami_wordpress.sql
    image11

At a later point, you may wish to restore the database. To restore the data to a fresh MySQL/MariaDB database from the command line, follow these steps:

  1. Launch a new Windows command shell using the "Shell" button in the XAMPP control panel.

  2. Use the mysql client to create a new, empty database to hold your data. In this example, the new database is named myblog.

    mysql --user=root --password="" -e "CREATE DATABASE myblog"

    Remember to use the correct database access credentials in the command. On a fresh XAMPP installation without any changes, you can usually log in as root with a blank password.

  3. Use the mysql client to import the contents of the backup file into the new database.

    mysql --user=root --password="" --database=myblog < bitnami_wordpress.sql

    The command-line client will now import the data from the backup file.

    image12

If you browse the contents of the database, you should now see your original data.

image13

You should now update your application’s configuration and point it to your newly-created database. For example, with the Bitnami WordPress module, you will need to edit the wp-config.php file in the apps\wordpress\htdocs\ subdirectory of your XAMPP installation directory. Within this file, you will need to update the DB_NAME constant to use the new database name.

image14