Hi all,
i need help in php mysql
am creating a web page for that i need to import and export database in sql format
please help me in this
its urgent
thanks in advance
rajasekar
Need help in exporting and importing database in mysql forma
Moderator: General Moderators
-
rajsekar2u
- Forum Commoner
- Posts: 71
- Joined: Thu Nov 20, 2008 4:23 am
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Need help in exporting and importing database in mysql forma
If you have phpmyadmin installed, copy the code from there 
-
rajsekar2u
- Forum Commoner
- Posts: 71
- Joined: Thu Nov 20, 2008 4:23 am
Re: Need help in exporting and importing database in mysql forma
I've phpmyadmin...
but i didnt got any php script for export or import in that.....
but i didnt got any php script for export or import in that.....
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Need help in exporting and importing database in mysql forma
Its not going to give you the scripts, you will have to dive into the source code!
-
rajsekar2u
- Forum Commoner
- Posts: 71
- Joined: Thu Nov 20, 2008 4:23 am
Re: Need help in exporting and importing database in mysql forma
If you have the mysql command line installed, you could use shell_exec to dump through it:
Replace username/password/database/path to fit your configuration.
Code: Select all
shell_exec("mysqldump -u[username] -p[password] -d --skip-add-drop-table [database] > path/to/database.sql");