I wouldn't use phpMyAdmin on a production server, I just don't trust any 3rd party web-app with admin access to my db server. The web-server gets basic CRUD permissions and all management is done via remote MySQL over a secure connection. I use http://www.heidisql.com/ (free/feature-full/fast).
Sorry, i think i don't get your question... mysql won't store your data in ordinary sql files it uses different files for different parts of the database information and it also depends on your database engine. as an example for MyISAM engine you have .MYD files for the table data, .MYI for table indices and .frm for the table definition. If you want to find out the path where all those files are stored, check the my.cnf file for the "[mysqld] datadir=" entry. if you want to manipulate the data in the database use the mysql-client command line tool or a WIndows GUI-Client like HeidiSQL
I can't recommend a desktop client like Sequel Pro or HeidiSQL enough. They get rid of all the hassle involved in installing, securing, and maintaining a server side solution like phpMyAdmin. Plus it eliminates the worry of big jobs timing out. Just plug in your private key and you're securely administering your databases over SSH with a nice local GUI.
Which DB are you using?
If it's MySQL, then http://www.heidisql.com/ is really great. Very easy to use, and doesn't get in your way like I've found many others to.
I'm also using it with Postgres, but it only partially supports it at this stage. It also support MS SQL, but I've never tried that.
HeidiSQL is a fairly intuitive MySQL DB viewer/editor for Windows. It should have everything you need, except the ctrl-c/ctrl-v stuff. That said, I would not want anyone that is not least a bit familiar with SQL databases editing anything on a production server.
I used that one before. But have switch to heidisql and can highly recommend it. Its a lot faster and only consumes a few 10Mb of memory unlike Workbench that continuously gobble up 100's Mb of memory. Still only for MySql though.
If you're on Windows check out http://www.heidisql.com/ - I switched over to it about 6 years ago, and couldn't stand going back to something web based.
If you're on another OS there's also http://dbeaver.jkiss.org/ which also supports lots of other DBs.
I use these two and enjoy them both very much: HeidiSQL (open source and needs to be run under wine) - http://www.heidisql.com/
Navicat for Mysql (commercial): http://www.navicat.com/products/navicat-for-mysql
For MySQL, HeidiSQL is the best I've ever used. It's simple to use, and most of actions are quickly doable. Here are a few things I like:
It supports MySQL and MSSQL. I'm trying PostgreSQL (experimental) with it, but there're many things missing (even if you already can use it to read your pSQL database)
First learn about SQL databases in general. Tables, Columns, Primary and Foreign Keys, Indexes, Normalization, Referential Integetry, Relations (m-n 1-n), SQL (the language)
Then setup a database (maybe MySQL or MariaDB). HeidiSQL is a very good GUI for these Databases.
After this is done learn how to connect via JDBC to your DB.
I stopped using PhpMyAdmin about a year or two ago, and I don't miss it at all.
If you're on Windows, check out http://www.heidisql.com/ - Much faster than using anything web based, and a more sensible interface in general. You can connect through SSH with it.
Otherwise there's a similar one written in Java... http://dbeaver.jkiss.org/ - I haven't tried it yet though.
I'll explain as best as I can, sorry if it's not good enough. I downloaded this: http://www.heidisql.com/installers/HeidiSQL_9.3.0.4984_Setup.exe from this: https://www.youtube.com/watch?v=f56_qyquO9A&t=328s youtube video. I'm trying to set up a Realm of the Mad God server so me and my friend can play on it. I run windows 7.
The only problem I'm having is coming from a program called heidisql and the sql file that downloads from the youtube video. It worked fine at first and I had the server up and running but my friend couldn't join so I tried to fix it but ended up messing it up. The heidisql program wouldn't let me undo what I had done and wouldn't let me re-add what I had deleted.
The only things I have to figure out is how to get the .sql file back to it's original state (because no matter how many times I uninstall heidisql, delete the sql file, reinstall/redownload it all, it's always the same file as it was before I uninstalled it all) and how to get it back to an .sql file (because now whenever I download the link it downloads as a .php file for some reason). If you need more info I can tell more or clarify what I have already said if needed.
Your statements might be too long, so MySql / MariaDb can't parse them fully.
When you create a dump, there's usually an option to split statements in smaller parts (e.g. only 1 Megabyte per statement). Example: The parameter "Max insert size" in HeidiSQL
Alternatively you could b increase the buffer size for SQL statements on the target database.
It sounds like your looking for is remote database administration software over SSH. I use HeidiSQL on Windows but there's also Sequel Pro for Mac and Navicat as a commercial cross-platform solution. You can also just SSH in and work over the command line.
Sweet jesus, just don't.
use something like http://www.heidisql.com/ for PC or http://www.sequelpro.com/ for OSX.
Don't ever import a DB this way to Pantheon. Pantheon is not your normal hosting situation.
When you first create a site, run the import then. And don't ever do it again.
Pantheon does custom things to the DB that change it from your initial import, and if you just try to import again, over it, you'll be in a world of pain.
It might be worth trying to do the migration with HeidiSQL - caveat: I haven't tried MSSQL->MySQL myself using this, but it works well for MySQL->MySQL.
Ideally though I think you need to identify what's causing the Migration Tool to freeze. Is it simply that there's so much data the tool is crashing, or could it be some edge case in the data causing the migration to fail?
All that said, are you sure it's actually failing and not just taking a very long time? If the Migration Tool isn't written with multi-threading in mind, it could just be that the UI is frozen while the program is tied up doing the import.
Hey, not to hijack the thread but I could use some help with icons for two programs that I would enjoy having made. HeidiSQL and SourceTree
Thanks for the help! If possible I think the source tree circuit would be pretty cool to include in the icon.
Yes. There are a lot of good ways to do it, but the lightest, simplest & most universal is with HeidiSQL. Just pop in your credentials (Host, name & password). Then you have access to the entire database. You can see the raw data see your views (which are predefined Select queries) launch stored procedures (predetermined actionable commands) or do anything else that you need from any computer.
While understanding the very basics of table creation will be essential, If you're on a windows system, I highly suggest Heidi SQL for managing a MySQL database. If you're on a Mac, Sequel Pro is very helpful. For Linux, Ubuntu at least, MySQL Workbench is one of many generally helpful database management tools. A database management program will really help simplify table creation and debugging. Instead of typing out long, error prone queries, you'll have a graphical interface that you can use to easily build tables and edit queries. Better yet, a good tool will show the queries and success messages that are run / received for tasks like table creation. You'll be able to get more comfortable with SQL query syntax as you go and you can replicate queries that you verify as working in the DB tool over in your PHP. This will reduce the need for you to immediately involve yourself with learning all the finite techniques required to debug DB query errors from the PHP side. Eventually, you'll need to learn fundamental database architecture and language. In the mean time, a DB management tool will go a long way to help you spend less time fudging around in a command console and more time actually learning.
You will have to move the DB over to godaddy or point the site to you r IP and give it access to the DB that way. Second option is not too easy. To export your DB use a program called http://www.heidisql.com/. It will make it very easy to export you DB
yes, I would get a portable webserver and a portable HeidiSQL, then use Heidi to create a table matching your columns and import the CSV into the server. If it is 40 GB, then it might take 30 minutes until the import is complete, but then you can use heidi to browse and filter the results.
As an alternative use the text file driver to access the CSV as SQL.
The only one that's come close is HeidiSQL, but even that is no where near the quality of SequelPro.
If there is good database manager out there for Linux, I hope someone can share it.
I use heidisql you'll need external access to the database. Heidisql also remembers your connections which comes in very handy, I don't have to look up the login details I just click on my client en I am connected.
edit: I accidentally a word
In addition to learning phpMyAdmin, check out this tool: HeidiSQL, which is a desktop application that works great (and personally much better) for local database work since it's not browser-based and therefore eliminates page refreshes and resulting quirks.
That being said, phpMyAdmin is the standard and will be on most MySQL installs, so be sure you know how to use that as well.