Inspiring

Question

DW can't open large sql database files

Forum|Forum|4 years ago
May 4, 2021
3 replies
2740 views

I exported a database using PHPmyAdmin and am unable to open it with DW. I get nothing but a blank page. However it does open with Notepad and I can see all the tables and data.

The file is rather large and includes two tables with 15 megabytes (form items and metadata) which I suppose I could empty, but I don't understand why the file opens in one application that is free on my Windows machine vs. an Adobe application for which I pay a monthly subscription fee!

This topic has been closed for replies.

P

Paul-M

Community Expert

SQLYog is good windows tool for working with MySQL/MariaDB .... There is a free community version and the paid version has some good sync and diff tools so you compare you local development databse's schema and/or data with remote.

Paul-M - Community Expert

BenPleysier

Community Expert

@Paul-M and @Nancy OShea

I think That the OP, @Liam Dilley and @B i r n o u are talking about is working on an SQL Dump file which is a normal text file. Notepad++ would certainly be my choice when Dreamweacer can't handle the size.

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!

P

Paul-M

Community Expert

@Paul-M correct me if I'm wrong, but SQLyog is not a code editor but a visual graphic tool to edit and monitor the Database ?

because, in fact, we're talking about code editor.

It is a visual editor for MySQL/MariaDB with advanced diff and sync tools in the paid version

Paul-M - Community Expert

Liam Dilley

Inspiring

This is not a workflow you should be doing.

It is not quite clear with your setup if your understanding a setup...

To run something as a localhost that is a dev/staging environment you need the web server features and SQL database to manage that.

If it is an apache/php/sql setup on the server you will need something like XAMPP setup and configured so it has the Apache and PHP environment and for you to then apply the SQL database there.

An SQL database is data and in a series of tables of data keys and their values. There is nothing in Dreamweaver you would be opening up that data to manage and edit.

If you are just looking to make bulk adjustments to database data you would be writing code to do that. Either direct or if is a CMS or platform driving it using their API to do that. OR you will be using an SQL database editor tool.

B i r n o u

Community Expert

@Liam Dilley excuse me, actually I don't understand the point you are trying to make. or maybe I don't understand the OP's question.

In fact, have you ever had to work on a SQL file as a text based database. it's something I practice daily.

Certainly PHPMyAdmin, or any other tools are interfaces that allow is to do it, but very often it is more practical, fast and efficient to intervene directly on the SQL DUMP with a code editor.

and that's where Dreamweaver often crashes, unlike editors like Note Pad++ or Sublime Text, but for that I have a large preference for Note Pad++

could you confirm if I have understood correctly or not the question of the OP and the point you want to address by talking about Xampp apache PHP ????

Liam Dilley

Inspiring

I have to really disagree about editing a text based version of an SQL database over any tool that can run command scripts on. That is crazy. Doing so on large complex relational databases would likely break them and take a lot longer!

I think reference Subline Text and Notepad++ shows where the space is in knowledge of modern code editors. If you get an amazon AWS instance the default on there these days is not Notepad++ any more 🙂

In terms of the OP, I was looking at why they would be trying to open an SQL database in any form in DW.

1. As I stated, editing in that form today vs the tools, apps and scripting to do that, especially with any form of relational database and even semi complex key structures, especiall if the solution has GUID referencing is crazy. I would be suprised if people can do it quicker that the actual modern tools SQL Manager that are there for that purpose. SO why they need to open in DW is still in question as a result.

2. I have seen people who have wordpress hosting they got and try to have a local copy running and do not understand about the setup you need to be able to run that locally. It is not the 1st, 5th or 10th time I have seen someone say they got their database and can not get their machine to run the website thinking if they get the SQL database it will just work.

DW will not ever do that and Adobe would be crazy to try to build that all in. It is already over bloated and slow compared to most modern editors. DW I started out and much old love for but its not on anyone's top editor lists of editors for site in 2020/2021.

Nancy OShea

Community Expert

Not sure what you're trying to do but SQL data needs to be imported into your database with phpMyAdmin, not opened in DW.

1. DW is not an SQL editor.

2. DW supports the following file types:

Nancy O'Shea— Product User & Community Expert

paulk7737514Author

Inspiring

Hi Nancy. I selected DW as the program to open SQL files because when I download a copy of a site's database I can open it in DW and save it in a site folder I name DB Backup or something similar. I'll just use Notepad instead.

Nancy OShea

Community Expert

I do that too. But I accomplish it without opening a file. Just save the SQL file to your default downloads folder and move it to your target destination. Start to finish, it takes me 20 seconds or less.

Nancy O'Shea— Product User & Community Expert

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded