No phpmyadmin? Lets get that database
Posted by: gerritvisagie on: October 27, 2011
Cant find the phpmyadmin login of a website you need to backup?
I found myself having this problem with a Joomla website that was about to transfer and a config file with just “Localhost” as the host address. Plus a support center that closed at 5pm sharp. Dont we all just love the bureaucratic way?
I was lucky that i had ftp details. if you dont have the ftp username. Wait for the support center to open… but if you do have the user here is a few quick things you can try to solve your problem.
Try pining the domain by opening command prompt.
run cmd.
type in: ping websiteadress.com
you should get somthing like this:
Now that you have the IP address of the server try typing into your url bar:
http://[your.ip.adress]:3306
Some hosts may redirect you to their phpmyadmin page .
Next up try http://88.10.315.138/phpmyadmin/
If your lucky this might also resolve your problem.
But if all else fails its time for some command line.
What you want to do is use the IP address to log into the SSH command line of the server.
the following commands can be used:
mysqldump -u databaseusername -p –all-databases >alldatabase.sql
Dumps all your databases in the hosting package
mysqldump -u databaseusername -p db_name >alldatabase.sqlfor use with specific databases
For a full list of functions: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
Do not forget the last >filename.sql or else you will only be dumping to screen.
Leave a Reply
Video Production | AD-land Corporate Video
- The Final ProductAD-land does small amount copies of up to 1000 copies for our clients. Designing the cover for the DVD case and the DVD itself is also within our capabilities.
- Staff Training VideosAd-land delivers high quality training videos for staff induction, training and orientation
- Editing your Corporate VideoThe real art of editing lies in the combination of music, visuals and voice in such a way that it will keep the audience interested and sell your company.
- Sales PresentationsThe structure of a sales presentation will mostly depend on the need of the company and the needs of their clients.
- The key points to marketing videoAD-land produce marketing videos that bring your message to life captivating your audience with sound and visuals of your business, striving to bring you interactive videos that get the job done.
- Interactive MultimediaWe create interactive multimedia for businesses; Delivering a professional level of interactivity is set by the design and application of the presentation.
- Better Multimedia PresentationsWe are in the business of building multimedia presentations for clients. We cannot provide the content, but we can transform a presentation into something that will captivate the audience.
- Safety Induction VideoAd-Land has produced this Safety Induction Video for BT Steel South Africa for their NOSA grading. The safety video with a total duration of 15 minutes and is a prime example of a Safety Induction Video.
- News and Updates | Ad-land ProductionsAd-land Productions, Production news, website updates, latest videos and website updates.Johannesburg South Africa. 0117952876 mail@ad-land.co.za
- Audio Video MarketingReach people through audio video marketing, a new and innovative way to show people what your company can do for them
