| Re: phpMyAdmin doesn´t export big tables |
| by M_1008 on 2012/3/1 13:00:52 Sadly, I don´t have access to the shell and neither to the main folder via ftp, for some reason I´m only allowed to write at httpdocs. I´ve installed sqlbuddy there and it looks a lot better than phpMyAdmin but I only get access to a subdomain database :/ Still waiting for an answer from the provider, I´ll post any progress. Thank you all anyway ;) |
| Re: phpMyAdmin doesn´t export big tables |
| by Peekay on 2012/2/29 14:22:17 At 1.2 GB it might be better to do this via shell (assuming you have access). To paraphrase the advice given on this site cd to the directory where you want to store your dump file, e.g. cd /var/www/vhosts/yourdomain.com/httpdocs/mydirectory Then tell mysql to dump it out: Quote: mysqldump –-add-drop-table -u the_db_username -p the_db_name > mybackup.sql It will prompt you for your password. The directory where you’re sending the dump file needs to be writeable by the server. You can then download the file via FTP. If it remains a problem, you may have to bite the bullet and ask your host to do this. |
| Re: phpMyAdmin doesn´t export big tables |
| by bjuti on 2012/2/29 13:43:36 Try http://sqlbuddy.com |
| Re: phpMyAdmin doesn´t export big tables |
| by M_1008 on 2012/2/29 12:29:50 With all the duplicates, they are 1.2 GB, but I´m interested about downloading only a half of them. Thank you for your answer, Peekay, I´ll try those programs. |
| Re: phpMyAdmin doesn´t export big tables |
| by Peekay on 2012/2/28 22:44:38 You might want to try a third-party app to download the DB, like SQLYog (used to have a free version) or you could grab the MySQL files (.MYI etc.) with an app like SiteVault (not free... but really good as an off-server FTP/DB backup tool). How big is the DB? (shown at the bottom of the 'size' column in PHPMyAdmin) |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|