Problems with phpMyAdmin

  • angelrebelde
  • Born
  • Born
  • angelrebelde
  • Posts: 1

Post 3+ Months Ago

Hello

Please need a little help that is no longer where to look and not how to solve this problem.
I tell you, I signed a hosting for my website but when I go into phpMyAdmin to backup the database appears as if you were inactive, as if I would not have that option.
The panel is to Plesk I read a lot of pages and the truth and not to believe and not to do.
Since most do not know what I got in touch with my hosting provider and I replied:
"We make copies of the BD, however since desacrgar phpmyadmin can also copy or make your script your application does not, which leaves the backup directory of your domain ina. "

I honestly do not explain why but I got them into this short answer....
Please could you help me get to the backup of the database, if something happens on my page I lose a lot of information.

Thank you for your attention and help

Greetings
angelrebelde
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • steve101
  • Beginner
  • Beginner
  • steve101
  • Posts: 35

Post 3+ Months Ago

You can use an SQL query like this

PHP Code: [ Select ]
$outfile='path/to/file.sql';
mysql_query("SELECT * INTO OUTFILE '$outfile' FROM `tablename`");
 
  1. $outfile='path/to/file.sql';
  2. mysql_query("SELECT * INTO OUTFILE '$outfile' FROM `tablename`");
  3.  


This query saves an SQL file (or backup if you prefer) of a particular table.

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 92 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.