datex Posted April 19, 2013 Share Posted April 19, 2013 Hi I need to export all my clients to a CSV file. I have tried using PhpMyAdmin Export - but for some reason - some of the special characters e.g. ø - gets out all wrong. Any idea how I can get out correct? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Chris Posted April 19, 2013 Share Posted April 19, 2013 Using MySQL via command line works to escape special characters where PhpMyAdmin fails. 0 Quote Link to comment Share on other sites More sharing options...
datex Posted April 19, 2013 Author Share Posted April 19, 2013 I use WHMCS to resell some services and have not access to the server (I'm using a shared Hosting account). Is it possible to connect using MySQL command line from a remote computer - or do I have other ways to retrieve the information. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Chris Posted April 19, 2013 Share Posted April 19, 2013 Hello, Generally yes, if you're using cPanel you can whitelist the remote computers IP address from the interface, and then use the command: mysql -u $db_user -p$db_pass $db_name -h $serverip To connect. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.