Penetration testing series - Part7: WordPress Penetration Testing
In this video tutorial, we went over a machine in cyberseclabs that goes by Boats. We did a typical penetration testing and we found a windows machine and a WordPress installation with PhpMyAdmin database that allows unauthenticated logins.
Video is here
submitted by MotasemHa
How do I properly backup my Database with specific encoding using mysqldump?
I have a WordPress website hosted with xampp on my local Windows machine which includes:
- Apache 2.4.46,
- MariaDB 10.4.14,
- PHP 7.4.10,
- phpMyAdmin 5.0.2,
- OpenSSL 1.1.1,
- XAMPP Control Panel 3.2.4,
- Webalizer 2.23-04,
- Mercury Mail Transport System 4.63,
- FileZilla FTP Server 0.9.41,
- Tomcat 7.0.105 (with mod_proxy_ajp as connector),
- Strawberry Perl 18.104.22.168 Portable
I have also installed MySQL Workstation & MySQL Shell
My Website is in Greek Language and I use an SQL File where I import its data in phpmyadmin.
The website's database is in utf8mb4_general_ci
When I import the data from Import in phpmyadmin, by default utf8 is selected. After the data is imported, I can see that the website is OK and everything is being shown as expected.
After the data import I run the following command
bash mysqldump -u user -puser --default-character-set=utf8mb4_general_ci --databases mydatabase > mydatabase.sql
After backing up and messing around with the website and experimenting with it I am trying to restore the database with
bash cmd.exe /c "mysql < mydatabase.sql".
Unfortunately, after restoring the database, my website is in gibberish Is there something I could do to be able to backup and restore my databases with mysqldump? https://bit.ly/3lLwfkU
Edit: There was nothing wrong about my commands. I found out that Powershell uses UTF 16 and when you are using mysqldump > db.sql or mysql < db.sql The data is getting transferred in UTF 16
The solution was to use command prompt instead
submitted by MariosFFX