Abdul Rahim wrote:
> Basically what I want to achieve is to move my
> entire database from the production enviroment to
> the user site. What I mean by scripting the
> database is to export the tables to the user's
> environment where I will instal and implement the
> system.
Have you considered using MySQL Migration Toolkit? This tool would be the perfect solution for you. Beside others it can migrate your MySQL schema from one server to another, either online or by creating a complete script.
Mike
Mike Lischke, MySQL Developer Tools
Oracle Corporation
MySQL Workbench on Github:
https://github.com/mysql/mysql-workbench
On Twitter:
https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to
http://bugs.mysql.com
MySQL documentation can be found here:
http://dev.mysql.com/doc/refman/8.0/en/