Most web hosting providers add phpMyAdmin to their control panel. This free and open-source tool has a user-friendly interface that allows you to run MySQL queries and manage your databases easily, including but not limited to exporting them. PhpMyAdmin is one of the most popular tools used to administrate MySQL databases. In this article, we will uncover how to use phpMyAdmin to export a database and create a backup. If you’re managing a MySQL database, phpMyAdmin can make the process hassle-free. Hope this was easy, share with your friends.The easiest way to backup or migrate your website’s data is by exporting your database. The only trick was to select proper File Origin which in this case was Unicode (UTF-8), may be for some other languages and file type you have to select different File Origin, but this is where you can play. as shown below see Arabic, Urdu, Pashto and Hindi all languages are correctly displayed this time. Now after completing importing your data will be ok, means non-English characters will not be broken. Now I will show you how we can avoid this while importing utf-8 or non-English data into MS Excel.ĭuring importing you see an option to select file origin It will import data BUT non-English characters will be broken as shown below Just click next, and select proper delimiter like comma or semicolon click from file in get external data section, as shown below. Now coming towards MS Excel How to import CSV in MS Excel Then select target csv format as shown in snap belowĬlick go button, it will download queried data in a CSV file. If you don’t know what is PhpMyAdmin it comes as WAMP or XAMP package, shortly this is a GUI interface to interact with MySQL databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |