I would like to export a table to a text file on the server as backup, preferably formatted (e.g. .csv). I have solved this on my local WAMP server, but cannot get this to function on my remote website.
The website support sent me a statement:
“/usr/bin/mysqldump -u User -pPassword -h [Host](Host as URL) Database_Name user > /var/www/skglimma.se/user.sql”
This seems to be a command line statement, but I would like to execute this programmatically as a query in PHP. Is this at all possible? I have checked the Internet and some solution use mysql or mysqld in their statements, but that has just generated errors each time, probably because it is used in a command line statement.
I would appreciate an example if anyone knows the solution.
Thanks in advance,