headadmin.net

Tag: MySQL

  • Import a mysql database from terminal

    mysql -u username -ppassword databasename < filename.sql Example Username: daniel Password: 123Headadmin Database name: my_new_db Database file name: my_old_db.sql mysql -u daniel -p123Headadmin my_new_db < my_old_db.sql

  • MySQL Warning: Using unique option prefix u instead of user is deprecated

    I have a script to dump the sql database to file. Now i get the message: Warning: Using unique option prefix u instead of user is deprecated and will be removed in a future release. Please use the full name instead. In my script I specified the user like this: –u daniel My solutions to […]

  • Rename a database in phpMyAdmin

    I wanted to change a MySQL database name via phpMyAdmin. This is how I did it: 1. Login to phpMyAdmin. 2. Select the database you want to rename. 3. Click on operations tab. 4. In the “rename database to” section, specifiy the new name of the database. 5. You will get a question saying “CREATE […]