Z
Z
zilhome2015-10-02 13:58:47
MySQL
zilhome, 2015-10-02 13:58:47

How would you recommend editing the SQL database offline (without phpmyadmin)?

There is a site database dump in a .GZ archive with a .SQL file in it.
I need to delete offline some values ​​in the database and import the file back into the site.
What is the best program to do this?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
Ruslan Fedoseev, 2015-10-02
@zilhome

text editor. You have a text dump.

E
Extor, 2015-10-02
@Extor

Maybe awk or sed if the base is big? No output to stdout.
If small - just a text editor.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question