Phpmyadmin restore
28/12/2017 11:47
Hi Does anybody know how to restore a database? Lets say I create database 'testing'. IN that db I create the table test (id, name). Then I make a few inserts in that table.

After a day I truncate that table. But I realize that it was really wrong.

If I go through phpmyadmin and try to export the database, I will see the structure of the tables, but not the data. Neither the inserts or the truncate directive.

In worst cases I can maybe access the database through the console. But right now IM struggling with phpmyadmin to see if there is a way to restore it from there.


Source is Usenet: comp.databases.mysql
Sign in to add a comment

Answer score: 5
28/12/2017 11:47 - -----BEGIN PGP SIGNED MESSAGE-----Hash: SHA1 *Sidenote*If you want to export something via phpmyadmin, make sure the option stuctureand Data is checked.

-----BEGIN PGP SIGNATURE-----Version: GnuPG v2.0.10 (GNU/Linux)Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAknQqAcACgkQE++2Zdc7EtfaYgCfRWTMqbcXZaQj4cRu+PqAdIqJXo8An2/o0ZXtwWURxI/BZuvrSxRadfpB=eZOp-----END PGP SIGNATURE-----

Source is Usenet: comp.databases.mysql
Sign in to add a comment

Answer score: 5
28/12/2017 11:47 - You can only restore something if you had previously backed it up.


Source is Usenet: comp.databases.mysql
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below