Database
- 21/02/2009
Back up the Mysql Phpmyadmin
(3 votes, average: 5.00 out of 5) 
Loading ... Personal speech alright?
Today I will talk about something very important for anyone who develops systems: BACKUP database!
But what good is a backup?
The backup is a way to prevent your system to lose important data, whether through carelessness of another user (human error), or by a fall of light, etc ...
Today you will learn how to make a backup of your database using Phpmyadmin .
I pre-suppose that you've seen or used the Phpmyadmin. So it is very easy. Just follow these steps:
- Open Phpmyadmin and select the database you want to backup;
- (3) se quiser fazer download do arquivo, se não marcar o backup será exibido na tela. Click the Export tab (1), in the following section to choose which tables will be part of the backup (2), check the Ships (3) if you want to download the file, if not select the backup will be displayed. And last click Run (4).
Ready! over!
It is very easy to backup, now you will only lose data if you want heheheh
The result of a backup is like the code below:
- - PhpMyAdmin SQL Dump
- - Version 2.11.9.3
- - Http://www.phpmyadmin.net
- -
- - Server: xxxxxxxxxxxxxxxxxxxxxxx
- - Generation Time: Feb 19, 2009 at 05:49 PM
- - Server version: 5.0.67
- - PHP Version: 5.2.6
- ; SET sql_mode = "NO_AUTO_VALUE_ON_ZERO";
- -
- - Database: `` marcelosabadini_noticias
- -
- --------------------
- -
- - Table structure for table `users`
- -
- ( CREATE TABLE IF NOT EXISTS `users` (
- 11 ) NOT NULL AUTO_INCREMENT , `Id` int (11) NOT NULL AUTO_INCREMENT,
- 50 ) NOT NULL , `Name` varchar (50) NOT NULL,
- 50 ) NOT NULL , `Email` varchar (50) NOT NULL,
- 12 ) NOT NULL , `User` varchar (12) NOT NULL,
- 12 ) NOT NULL , `Password` varchar (12) NOT NULL,
- , Data_cadastro `` datetime NOT NULL,
- ( `id` ) UNIQUE KEY `id` (`id`)
- CHARSET=latin1 AUTO_INCREMENT = 4 ; ) ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 4;
- -
- - Dumping data for table `users`
- -
- ( `id` , `nome` , `email` , `usuario` , `senha` , `data_cadastro` ) VALUES INSERT INTO `users` (`id`, `name`, `email`, `User`, `password`, `data_cadastro`) VALUES
- , 'Marcelo Sabadini' , 'marcelosabadini@gmail.com' , 'marcelosabad' , '123456′ , '2008-10-30 15:22:00′ ) , (1, 'Marcelo Sabadini', 'marcelosabadini@gmail.com', 'marcelosabad', '123456 ', '2008-10-30 15:22:00'),
- , 'Teste2′ , 'teste2@teste.com.br' , 'teste2′ , 'teste2′ , '2008-10-30 16:24:22′ ) , (2, 'Test2', 'teste2@teste.com.br', 'test2', 'test2', '2008-10-30 16:24:22 '),
- , 'Um usuário para teste online' , 'teste@testes.com.br' , 'novouser' , 'novouser' , '2008-12-28 18:43:29′ ) ; (3, 'A test user online', 'teste@testes.com.br', 'novouser', 'novouser', '2008-12-28 18:43:29 ');
To return to (import) a backup just click on the Import tab.
I hope I have been helpful! A big hug!
1 Trackback (s)