Hi Experts
I want to export MSSQL tables to phpMyAdmin. Is there anyway to create phpMyAdmin MSSQL connection? I have tried a lot but positive results. Please share the process of doing it
Dear,
At first open your computer then download xampp software and install then open xampp software . run Apache and MySQL. then open your any browser write localhost on title bar and then enter .create your phpmyAdmin
Hi Williumm,
To connect MySQL database using phpMyAdmin you can try the following
Open your browser and go to www.HostMySite.com
Click on Control Panel Login
Long into the control Panel as an Account Administrator and select domain or technical contact for the domain.
Then click on MySQL Databases set UserName as database Server address as 10.10.0.229 DB Administration as phpMyAdmin
This should sort you out.
Thank you.
Hello,
Looking at the difference between the two files will show you some things to check out.
mysqldump --compatible=mssql -uroot -p some_database > output_file_mssql.sql
vs
mysqldump -uroot -p some_database > output_file.sql
If you cannot access a way for phpMyAdmin to create an exported file of the right format, then you'll need to edit the resulting exported file to make it work with MS SQL.
If you need to export data frequently, you can find that writing a short text processing script which you can run again as needed and will save your time.
And take care your text editor can properly handle the character encoding of the file generated by phpMyAdmin.
