Advanced Search

Return to Snippet

Revision: 41650
at February 22, 2011 00:53 by mitnworb
Initial Code 
Backup

mysqldump -u user_name -p[your_password] database_name > File_name.sql

This will only work if the database does not already exist:

mysql - u user_name -p your_password database_name < file_name.sql

Or using our example from the previous page:

If your database already exists and you are just restoring it, try this line instead:

mysqlimport -u user_name -p[your_password] database_name file_name.sql
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Backup and Restore Mysql 

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL