Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
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?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

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

text editor. You have a text dump.

Report
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.

Similar questions
Q
Questions00012021-05-07 16:07:05
How to bypass intrusive Youtube ads? ad blockers don't help. You need to switch to a paid plan to stop ads. What can be done? 4Reply
G
GaserV2017-06-24 02:43:34
How to return the user who sent the message in Laravel? 5Reply
S
synapse_people2021-05-17 11:49:28
What should be the gt files for learning? 0Reply
V
Vladimir2017-07-04 13:29:51
How to prevent a route change on $routeChangeStart so that $routeChangeError will work after? 2Reply
N
Nikolai Steshenko2021-05-24 00:59:15
How to add a field to registration or remove instantaCms? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question