Skip to main content
Minor improvements.
Source Link
Pang
  • 10.2k
  • 146
  • 87
  • 126

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

If you want to ignore foreign key checks, you can uncheck the box that says:

[ ] Enable foreign key checks

You'll need to be running atleastat least version 4.5.0 or higher to get this checkbox.

ItsIt's not MySQL CLI-fu, but hey, it works!

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

If you want to ignore foreign key checks, you can uncheck the box that says:

[ ] Enable foreign key checks

You'll need to be running atleast version 4.5.0 or higher to get this checkbox.

Its not MySQL CLI-fu, but hey, it works!

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

If you want to ignore foreign key checks, you can uncheck the box that says:

[ ] Enable foreign key checks

You'll need to be running at least version 4.5.0 or higher to get this checkbox.

It's not MySQL CLI-fu, but hey, it works!

Added a note about minversion
Source Link
Nemo
  • 3.2k
  • 2
  • 32
  • 46

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

If you want to ignore foreign key checks, you can uncheck the box that says:

[ ] Enable foreign key checks

You'll need to be running atleast version 4.5.0 or higher to get this checkbox.

Its not MySQL CLI-fu, but hey, it works!

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

If you want to ignore foreign key checks, you can uncheck the box that says:

[ ] Enable foreign key checks

Its not MySQL CLI-fu, but hey, it works!

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

If you want to ignore foreign key checks, you can uncheck the box that says:

[ ] Enable foreign key checks

You'll need to be running atleast version 4.5.0 or higher to get this checkbox.

Its not MySQL CLI-fu, but hey, it works!

added note about foreign key constraints
Source Link
Nemo
  • 3.2k
  • 2
  • 32
  • 46

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

If you want to ignore foreign key checks, you can uncheck the box that says:

[ ] Enable foreign key checks

Its not MySQL CLI-fu, but hey, it works!

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

Its not MySQL CLI-fu, but hey, it works!

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

If you want to ignore foreign key checks, you can uncheck the box that says:

[ ] Enable foreign key checks

Its not MySQL CLI-fu, but hey, it works!

deleted 3 characters in body
Source Link
Jakob S
  • 20.2k
  • 3
  • 42
  • 38
Loading
Source Link
Nemo
  • 3.2k
  • 2
  • 32
  • 46
Loading