[PHP-DB] Obj : [PHP-DB] Renaming a database name...
Hi Arief ! Well, you should use PhpMyAdmin who can do many usefull things. Like rename, optimize, make requests etc ... (If you're in local. Some providers refuse this.) http://phpmyadmin.sourceforge.net/ Or see the ALTER TABLE function in the doc. bye Fabien. Arief Fajar Nursyamsu a écrit : > Dear All... > > Can I rename a database name ? > > Regards > > rief > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Renaming a database name...
On Thu, Sep 20, 2001 at 05:04:37AM +0700, Arief Fajar Nursyamsu wrote: > Can I rename a database name ? I don't know what database you are using, but you should be able to do something like this with most of them. Do a backup of the database. Create a new database with the new name. Restore the old database to the new database. -- Jason Stechschulte [EMAIL PROTECTED] -- Beauty? What's that? -- Larry Wall in <[EMAIL PROTECTED]> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Renaming a database name...
> > Can I rename a database name ? > There is no command to do so. Have you tried simply renaming > the files and sub-directory where the database files are located? > I've not tried that. Simply renaming could be dangerous. You can do this: mysqldump old_database_name > old_database_name.txt mysqladmin create new_database_name cat old_database_name.txt |mysql new_database_name mysqladmin drop old_database_name of course, this is only going to work if you have MySQL and have access to the mysqladmin program. :p Chris
RE: [PHP-DB] Renaming a database name...
There is no command to do so. Have you tried simply renaming the files and sub-directory where the database files are located? I've not tried that. -Original Message- From: Arief Fajar Nursyamsu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 5:05 PM To: PHP-DB Subject: [PHP-DB] Renaming a database name... Dear All... Can I rename a database name ? Regards rief -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Renaming a database name...
Dear All... Can I rename a database name ? Regards rief -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]